Unformatted text preview: dvanced Topics in Data Recovery
Which three files should be backed up for a closed database backup? (Choose two)
Answer: A, C, D
Data, control and password files need to be backed up for a closed database backup.
B: Alert file does not need to be backed up during a closed database backup.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 574-594
Chapter 12: Overview of Backup and Recovery
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
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.
A: A time-b...
View Full Document
- Fall '09
- Jason S. Couchman, DBA Certification Exam, Certification Exam Guide