Exhibit
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 1 0g: New features for Oracle 8i, 18-21
and Oracle(r) 10g Backup and Recovery