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';

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---