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



www.unisoftindia.org


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>
15) 
    run  
     {  
       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.

Comments

Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command