Com the power of knowing 1z0 025 question 57 your

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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) Answer: B Explanation: 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.

Ask a homework question - tutors are online