This preview shows page 1. Sign up to view the full content.
Unformatted text preview: on to this rule is when your database experiences media failure and no
online redo log has been overwritten by LGWR. In this case, you need only restore the
datafile lost by media failure and let Oracle handle crash recovery.
A: You can restore only damaged files if no log switch has occurred once the last
backup. In other case, when LGWR rewrote redo logs, you need to restore all datafiles,
redo logs, and control files.
C: Not only consistent datafiles need to be restored, but redo logs, and control files also.
D: Not only datafiles need to be restored, but redo logs, and control files also.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 666-671
Chapter 14: Database Failure and Recovery
Your archive logs are not restored to the ARCHIVE_LOG_DEST directory. What
are three ways to notify Oracle server of their location? (Choose three)
A. Specify the location and name when prompted for a log.
B. Use the ALTER SYSTEM SWITCH LOGFILE command.
C. Use the...
View Full Document
- Fall '09