Question 4) 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

Single Answer Multiple Choice

 

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:

 

RMAN>BACKUP DATABASE;

 

At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command.

 

Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command?

 

A. Start the database in the MOUNT stage.
B. Back up the control file to trace.
C. Set the DBID.
D. Issue the RECOVER DATABASE command.

 

Answer:
C. Set the DBID.

 

Tutorial:
Before restoring the control file from the autobackup, you are required to specify the database ID (DBID) to identify the database that you are connecting to. The control file contains information about the database ID, and the failure makes the control file unavailable. The syntax for specifying the database ID is as follows:

 

RMAN>SET DBID database_id;

 

The option stating that you must start the database in the MOUNT stage before restoring the control file is incorrect. This is because the control file is used to start the database in the MOUNT stage. You are required to start the database in the MOUNT stage after restoring the control file from the autobackup.

 

The option stating that you must back up the control file to trace before restoring the control file from the autobackup is incorrect. You must back up the control file to determine whether you are re-creating the control file because the BACKUP CONTROLFILE TO TRACE command creates a script that is used to re-create the control file.

 

The option stating that you must execute the RECOVER DATABASE command before restoring the control file from the autobackup is incorrect. This is because the RECOVER DATABASE command must be issued after restoring the control file from the autobackup.

 

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

 

Oracle Database Backup and Recovery Advanced User’s Guide
10g Release 1 (10.1)
Part Number B10734-01
Chapter: 8 Advanced RMAN Recovery Techniques
Topic: Performing Recovery with a Backup Control File and No Recovery Catalog
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmrecov.htm#1006329

 

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: