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 22 7: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 Basics, 3-4