Oracle OCP 1Z0 053 Q607

607.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.
Answer: D

因為控制檔案裡有記錄著備份的資訊，當控制檔案丟失，和線上重做日誌丟失，只能做不完全恢復，並且只能恢復控制檔案來來做不完全恢復。

參考：http://blog.csdn.net/rlhua/article/details/14649045

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2073230/，如需轉載，請註明出處，否則將追究法律責任。