This preview shows page 1. Sign up to view the full content.
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
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';
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.
- Fall '09