This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Power of Knowing 1Z0-025 QUESTION 57:
Your database is in NOARCHIVELOG mode, and a media failure occurs. Which
files do you need to restore to minimize data log?
A. The damaged files only.
B. The damaged files only if no log switch has occurred once the last backup.
C. All database files that are consistent from the same backup set if a log switch has
occurred since the last backup.
D. All data files that can be a mix from any backup set if a log switch has occurred since
the last backup (You can take them from different backup sets if you like)
You need to restore just damaged files to minimize data log if no log switch has occurred
once the last backup. When media failure occurs on the database in NOARCHIVELOG
mode, you must restore all datafiles, redo log files, and control files from your backup in
order to recover the database, even if only one file on disk was lost. This is because all
datafiles, redo logs, and control files must be synchronized in order for the database to
open. One excepti...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09