1Z0-025 Free Dumps Study Materials
Question 8: The instance crashed after the current online redo-log becomes corrupt. Which action can the
DBA take to open the database?
A. Perform a tablespace recovery.
B. Recover the SYSTEM tablespace.
C. Perform a complete recovery of the database.
D. Skip recovery and open the database with the RESETLOGS option.
E. Perform a time-based recovery that stops at the time that the current online redo-log became
corrupt.
Correct Answer: E
Explanation:
To fix problem with corrupted current online redo log file after instance crash you need
to perform a time-based recovery that stops at the time that the current online redo log
became corrupt and open the database after that.
Incorrect Answers:
A: A time-based recovery needs to be done, not tablespace recovery, in this situation.
B: You don't need recover the SYSTEM tablespace.
C: You need to perform an incomplete time-based recovery, not a complete recovery.
D: You must perform a time-based recovery, don't skip it before RESETLOGS option. Oracle 8, DBA
Certification Exam Guide, Jason S Couchman, p. 704-711 Chapter 15: Advanced Topics in Data
Recovery