POINT IN TIME RECOVERY (Current Control File)
Note: Database is running in ARCHIVELOG mode
A TABLE WAS DROPPED AT 12:05 ON 3rd JAN, 2000. THE TABLE HAS TO BE RECOVERED USING POINT IN
TIME RECOVERY, SAY TILL TIME 12:03 ON 3rd JAN, 2000, JUST BEFORE THE TABLE WAS DROPPED.
RESTORE ALL THE DATAFILES FROM A BACKUP TAKEN BEFORE THE INTENTDED POINT OF RECOVERY,
HOWEVER IF A DATAFILE IS ADDED AFTER THE INTENDED POINT OF RECOVERY IT IS NOT NECESSARY
TO RESTORE THAT FILE.
DO NOT RESTORE THE CONTROL FILE AND REDO LOGFILES.
SVRMGR> STARTUP MOUNT
SVRMGR>> RECOVER DATABASE UNTIL TIME '2000-01-03:12:03:00'.
Apply REDO Log Files.
SVRMGR>> ALTER DATABASE OPEN RESETLOGS;
CHECK IF THE TABLE EXISTS.
IMP : TAKE A FULL OFFLINE BACKUP.
(The old Backup cannot be used to perform a recovery after resetting the logs)