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

what is a user-defined lock?

0 Answers   Oracle,


how does an oracle clusterware manage crs resources?

0 Answers   Oracle,


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

3 Answers  


When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  


what are the differences of where and if in SAS?

0 Answers  






What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  


which background process will run @ the time of creation of catalog database

1 Answers   CSC,


How would you force a log switch?

4 Answers  


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

1 Answers  


Name a tablespace automatically created when you create a database.

5 Answers  


Categories