Identify the required steps in the correct order.

Your database is running in archivelog mode and regular nightly backups are taken. Due to
a media failure, the current online redo log group, which has one member, is lost and the
instance is aborted. Examine the steps to recover the online redo log group and move it to a
new location. 1.Restore the corrupted redo log group. 2.Restore the database from the most
recent database backup. 3.Perform an incomplete recovery. 4.Relocate the member of the
damaged online redo log group to a new location. 5.Open the database with the resetlogs
option. 6. Issue a checkpoint and clear the log. Identify the required steps in the correct
order.

Your database is running in archivelog mode and regular nightly backups are taken. Due to
a media failure, the current online redo log group, which has one member, is lost and the
instance is aborted. Examine the steps to recover the online redo log group and move it to a
new location. 1.Restore the corrupted redo log group. 2.Restore the database from the most
recent database backup. 3.Perform an incomplete recovery. 4.Relocate the member of the
damaged online redo log group to a new location. 5.Open the database with the resetlogs
option. 6. Issue a checkpoint and clear the log. Identify the required steps in the correct
order.

A.
6, 4, 3, 5

B.
1, 3, 4, 5

C.
6, 3, 4, 5

D.
2, 3, 4, 5

Explanation:



Leave a Reply 1

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