Performing Database Recovery

Posted on
Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

These questions are derived from the Self Test Software Practice Test for 1Z0-042 – Oracle Database 10g: Administration I.

 

Objective: Performing Database Recovery
SubObjective: Recover from loss of a redo log file

 

Item Number: 1Z0-042.16.2.3
Single Answer, Multiple Choice

 

The disk on which your redo log file is located is corrupted. As a result, you decide to relocate the redo log file to a different disk.

 

After you shut down the database, which actions can you take to relocate the redo log file in your database?

 

 

  1. Use the OS commands to move the file and then update the parameter file.
  2. Mount the database and issue the ALTER DATABASE statement to move the file and then update the control file.
  3. Mount the database, use OS commands to move the file and issue the ALTER DATABASE…RENAME FILE statement.
  4. Use the OS commands to move the file, mount the database and issue the ALTER DATABASE…RENAME FILE statement.
  5. Copy the existing redo log file to the desired location by using OS commands. Then restart the instance and use the ALTER SYSTEM statement to update the control file.

 

Answer:
D. Use the OS commands to move the file, mount the database and issue the ALTER DATABASE…RENAME FILE statement.

 

Tutorial:
You can relocate a redo log file in your database by adding a new log file and dropping the old log file or by using the ALTER DATABASE…RENAME FILE statement. To use the ALTER DATABASE…RENAME FILE statement, you should:

 

 

  1. Shut down the instance.
  2. Use the OS commands to move the file.
  3. Mount the database.
  4. Issue the ALTER DATABASE…RENAME FILE statement to update the control file. The new file must exist before you issue this statement or the statement will fail.
  5. Open the database.

 

The option to use the OS commands to move the file, and then update the parameter file is incorrect because you do not need to edit the parameter file to relocate a redo log file in your database.

 

The option to mount the database and issue the ALTER DATABASE statement to move the file and update the control file is incorrect because you do not use the ALTER DATABASE statement to move the file. The files are moved by using the OS commands. In addition, the ALTER DATABASE…RENAME FILE statement is used to update the control file.

 

The option to mount the database, use the OS commands to move the file, and issue the ALTER DATABASE…RENAME FILE statement is incorrect because the files should be moved before mounting the database.

 

The option that states that you must use the ALTER SYSTEM statement to update the control file is incorrect because the ALTER DATABASE…RENAME FILE statement is used to update the control file.

 

Reference:
1. Oracle University – Oracle Database 10g: Administration Workshop I – Chapter 20: Database Recovery – Loss of a Redo Log File
D17090GC10
Edition 1.0
March 2004
D39126

 

2. Oracle University – Oracle Database 10g: Administration Workshop I – Chapter 16: Performing Database Recovery – Loss of a Redo Log File
D17090GC20
Edition 2.0
August 2005
D21638

 

3. Oracle Database Backup and Recovery Advanced User’s Guide 10g Release 2 (10.2)
Part Number B14191-02
Chapter: 19 Advanced User-Managed Recovery Scenarios
Topic: Recovering After the Loss of Online Redo Log Files: Scenarios
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen008.htm#sthref1872

 

4. Oracle Database Administrator’s Guide 10g Release 2 (10.2)
Part Number B14231-02
Chapter: 6 Managing the Redo Log
Topic: Relocating and Renaming Redo Log Members
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/onlineredo.htm#sthref951

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:

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>