Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
28 views



Related Hot Questions



Government Jobs Opening


...