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

Question Posted / guest

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

More DB Administration Interview Questions

What is a correlated sub-query? : sql server DBA

What background process refreshes materialized views?

What authentication modes does sql server support? : sql server DBA

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

why do we give pctfree and pctused in create table statement?

how can you communicate with operating system files from oracle?

How would you go about generating an EXPLAIN plan?

what is the use of home directory???

WHEN DOWN TIME WHAT CAN U DO?

how can you create a user-defined lock?

internal architecture

For more DB Administration Interview Questions Click Here