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

internal architecture

0 Answers   CSC,


who owns the operating system files created by the utl_file package?

0 Answers   Oracle,


suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  


how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,


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

0 Answers  


How can we see the database version in os level

6 Answers   Oracle,


WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,


the process of adding a cpu in sql server is called..?

2 Answers   TCS,


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  


Categories