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

Incomplete Recovery Using Rman ( Scn No )

1.      First database in Archivelog mode.
2.      Tack a Rman Backup (Rman> backup Database; ) command
3.      Take a current scn no first time
4.      select timestamp_TO_SCN(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 timestamp_TO_SCN(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 Scn < Scn_No >;  
        Restore Database;  
        Recover Database;  
        Alter Database Open Resetlogs;  
     16.  Check table parag5 is back but after the second scn no table or data is lost permanently. These data is no recover or back.


Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

Oracle Database SQL - Practise - Question - Scott Schema Examples

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