|
Explanation: In this situation cancel-based incomplete recovery can be used, so the RECOVER DATABASE UNTIL CANCEL command is appropriate answer for this question. Incorrect Answers: 2: There is no RECOVER option in the ALTER TABLE SPACE system command in Oracle. 3: The RECOVER TABLE SPACE system UNTIL CANCEL command will not work in this situation. 4: The UNTIL MISSING REDOLOG is wrong option in RECOVER DATABASE command. 5: The RECOVER DATABASE USING BACKUP CONTROLFILE command will not help to recover corrupted redo log file. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 703-706 Chapter 15: Advanced Topics in Data Recovery
|