Question 2) Oracle Database 10g Administration

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

Single Answer Multiple Choice

 

The online redo log group configuration for your database is as follows:

 

What will happen if the online redo log file ‘ora02/oradata/redo02b.log’ is corrupted while working on the database?

 

A. The database will hang.
B. The database will crash.
C. The database will shut down.
D. The LGWR process writes redo log entries to the other redo log member of the Group2 group.

 

Answer:
D. The LGWR process writes redo log entries to the other redo log member of the Group2 group.

 

Tutorial:
In this scenario, the online redo log groups are multiplexed. While multiplexing the online redo log files, it is preferable to keep the members of a group on different disks to ensure that one disk failure does not affect the ongoing operation of the database. If the LGWR process can write the redo log entries to at least one member of the group, the database operation proceeds as normal. An entry is written to the alert.log file.

 

The other options stating that the database will hang or crash, or shut down due to the failure of a redo log member are incorrect.

 

Reference:
Oracle Database 10g: Administration Workshop II
Chapter 13: Monitoring and Managing Storage

 

Oracle Database Administrator’s Guide
10g Release 1 (10.1)
Part Number B10739-01
Chapter: 6 Managing the Redo Log
Topic: Multiplexing Redo Log Files
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/onlineredo.htm#sthref809

 

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

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>