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

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

why we use cursors

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?

0 Answers   HSBC,

---