One the evening of April 22, you are working on a database created using Oracle Database 10g.
This database operates in the ARCHIVELOG mode. You discover that you need crucial data that
was dropped from the database at 8:00 A.m. No full backup has been taken after April 15. What
would you do?
A.
recover the database until April 10
B.
recover the database until April 15
C.
recover the database until 227:59 A.m.
D.
recovery is not possible; manually re-create the object
Explanation:
RMAN simplifies recovery operations using backups taken from earlier database incarnation so
that it is easy as recovering a backup from the same incarnation. The simplified recovery through
RESETLOGS feature is an enhancement to recovery operations so that previous incarnation
backups can be used for recovery of the current database incarnation. You use this feature when
you have performed an incomplete recovery (or a recovery using a backup control file) and
opened the database with the RESETLOGS option. To perform incomplete recovery, use the SET
UNTIL command to specify the time, SCN, restore point, or log sequence number at which
recovery terminates. Alternatively, specify the UNTIL clause on the RESTORE and
RECOVER commands. REF.: Oracle(r) Database 10g: New features for Oracle 8i, 18-21 and
Oracle(r) 10g Backup and Recovery