What command would you use to create a backup control file?

Answers were Sorted based on User's Feedback



What command would you use to create a backup control file?..

Answer / ram

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

Is This Answer Correct ?    6 Yes 0 No

What command would you use to create a backup control file?..

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB Administration Interview Questions

Explain CREATE DATABASE syntax?

2 Answers  


what is the differnce between process and thread ?

1 Answers   IBM,


how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,


What view would you use to look at the size of a data file?

3 Answers  


What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  






mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,


What is the difference between online backup & offline backup?

3 Answers   CSC,


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  


What is the default fill factor value? : sql server DBA

0 Answers  


From the database level, how can you tell under which time zone a database is operating?

1 Answers  


How would you go about verifying the network name that the local_listener is currently using?

0 Answers  


Categories