Examine the following scenario:
– Database is running in ARCHIVELOG mode.
– Complete consistent backup is taken every Sunday.
– On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted
– The disk having active online redo log files is also corrupted.
– The hardware is repaired and the paths for online redo log files and control files are still valid.
Which option would you use to perform the recovery of database till the point of failure?
A.
Restore the latest whole backup, perform complete recovery, and open the database normally
B.
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.
C.
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.
D.
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
The Correct Answer should be B.
Flaws with the last option what I can think of
– What if the data in few of the blocks was written by DBWR for the redo logs present in current online redo log files.
And supposedly that transaction was not committed?
– Restore full backup.
– Perform Incomplete recovery till the time archive logs are there
– Open with resetlogs option.
You lost your control files, you have to recover from that first. So D is the right answer.
also you lost your redo logs, that means the redo ins’t enough to recover DB.
So B is right.