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

Question Posted / guest

2 Answers
5314 Views
I also Faced
E-Mail Answers

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 happens on checkpoint? : sql server DBA

0 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

how to restore files with rman?

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

how will you see when the database was started using sql prompt?

2 Answers IBM,

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

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

1 Answers CTS,

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

Explain CREATE DATABASE syntax?

2 Answers

Datapump backup steps?

1 Answers

For more DB Administration Interview Questions Click Here