Question 3) Oracle Database 10g Administration

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Objective: Database Recovery
SubObjective : Recover the Control File

 

Single Answer Multiple Choice

 

You issued the following statement:

 

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

 

What will be the result of issuing the statement?

 

A. The control file will be multiplexed.
B. The control file will be recreated.
C. The script containing the CREATE CONTROLFILE statement will be created.
D. The binary backup of the control file will be created.

 

Answer:
C. The script containing the CREATE CONTROLFILE statement will be created.

 

Tutorial:
The script containing the CREATE CONTROLFILE statement will be created. The script is created by using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement. This statement generates an ASCII representation of the binary control file as an Oracle trace file. The ASCII backup control file can be used to rebuild the binary control file.

 

The option stating that the control file will be multiplexed is incorrect. The control file is multiplexed by copying the control file to another disk and by making the changes in the initialization parameter file, the spfile, and the current control file.

 

The option stating that the control file will be re-created is incorrect. To re-create the control file, you are required to run the script created by the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement.

 

The option stating that the binary backup will be created by executing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement is incorrect. The binary backup will be created by executing the ALTER DATABASE BACKUP CONTROLFILE TO <path> statement. The control file can be created by using the RECOVER DATABASE UNTIL TIME <value> USING BACKUP CONTROLFILE command.

 

Reference:
Oracle Database 10g: Administration Workshop II
Chapter 8: Database Recovery

 

Oracle Database Administrator’s Guide
10g Release 1 (10.1)
Part Number B10739-01
Chapter: 5 Managing Control Files
Topic: Backing Up Control Files
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/control.htm#sthref766

 

These questions are derived from the Self Test Software Practice Test for Oracle exam #IZ0-043: Oracle Database 10g: Administration II.

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: