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 are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

1 Answers   HSBC,

---

Give the reasoning behind using an index.

2 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

Explain the concept of the DUAL table.

3 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---