Perform Time Base Incomplete recovery Using Rman in Oracle 10g & 11g


Incomplete Recovery Using Rman (Time Base )

1)    First database in archivelog mode.
2)    Tack a Rman Backup (Rman> backup Database; ) command
3)    Take a current Timestamp first time
4)    select CURRENT_TIMESTAMP from dual;
5)    Create parag to parag9 tables and switch log file after 3 tables.
6)    Take a current scn no Second time
7)    select CURRENT_TIMESTAMP from dual;
8)    Drop table parag5.
9)    Create parag10 to parag13 tables and switch log file after 3 tables.
10)  After some time I want to these drop parag5 table back this is the important table;
11)  These table backup and archivelog is not available that time incomplete recovery is doing.
12)  Go to rman window rman>
13)  Run these command
14)  RMAN>
       Shutdown Immediate  
       Startup Mount  
       Set Until Time= ’02-Mar-2015 02:23:15’;  
       Restore Database;  
       Recover Database;  
        Alter Database Open Resetlogs;  

16)  Check table parag5 is back but after the second Timestamp table or data is lost permanently.  These data is no recover or back.

Most Trending