D copying the data files is not first step to restore

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: a files is not first step to restore data files to a new location. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 637-641 Chapter 13: Using Recovery Manager for Backups QUESTION 37: When starting up the database you find that an inactive, unarchieved redo-log group is corrupted. What should you do? A. RECOVER REDOLOG GROUP 1; B. RECOVER DATABASE UNTIL CANCEL; C. ALTER DATABASE RECOVER REDOLOG; D. ALTER DATABASE CLEAR UNARCHIEVED LOGFILE GROUP 1; E. RECOVER DATABASE UNTIL TIME '1999-09-15:11:23:0'; Answer: D Explanation: If found corrupted redo log group is an inactive and not archived, you can use the ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1 command to clear this redo log group. Issuing this statement will eliminate all redo information in the database redo log group specified. Only redo logs that have a status of inactive can be cleared. If the redo log being cleared has already been archived, then the DBA should not use the UNARCHIVED keyword. In the event that...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online