Ask a Question
Advertise on boostr.in
boostr.in questions - Question:A media failure occurred causing NOARCHIVELOG mode database to crash. It was discovered that two of the data files are corrupt. The last whole closed database backup was taken one week ago with a online redo log sequence number of 83. At the time the data files were corrupted, the online redo log sequence number was 85. Although there were few committed transactions after the last backup, as much data as possible has to be recovered. Which recovery process should be used?
a. ¬†¬†¬†¬†¬†¬†¬†Shut down the instance, restore all of the Oracle files from the most recent backup, and restart the instance
b. ¬†¬†¬†¬†¬†¬†¬†Manually restore and recover the two corrupt data files from the most recent backup
c. ¬†¬†¬†¬†¬†¬†¬†Shut down the instance, restore the two corrupt data files from the most recent backup, and restart the instance
d. ¬†¬†¬†¬†¬†¬†¬†Shut down the instance, restore all of the Oracle files from the most recent backup, restart the instance, and open the database using the 'ALTER DATABASE OPEN RESETLOGS' statement
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please