Answer / ram

alter database backup controlfile '\path';
alter database backup controlfile to trace;

Answer / simhadri naidu

At offline backup copy the CTL file to back up location.
At online backup
Alter database backup controlfile to trace as '/path';

How many memory layers are in the shared pool?

3 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---