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 the use of home directory???

Why does Oracle not permit the use of PCTUSED with indexes?

1)how to Take Backup in sql server 2005 from Flash Drive

How would you determine what sessions are connected and what resources they are waiting for?

What is transparent data encryption? : sql server DBA

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

Where do you find the default index fill factor and how to change it? : sql server DBA

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

what is a user-defined lock?

For more DB Administration Interview Questions Click Here