Perform Incomplete Recovery Until Time Using Rman in 10g and 11g

1. First database in archivelog mode.
2. Take a Rman Backup.

      Rman> Backup Database;

3. Take a current Timestamp first time

      Sql > Select current_timestamp from dual;

4. Create parag to parag9 tables and switch log file after 3 tables.

5. Take a current scn no Second time   

      Sql > Select current_timestamp from dual;

6. Drop table parag5.

7. Create parag10 to parag13 tables and switch log file after 3 tables.

8. After some time I want to these drop parag5 table back this is the important table;

9. These table backup and archivelog is not available that time incomplete recovery is doing.

10. Go to Rman window Rman>

11.  Run these command      

    Rman> run    
         {    
            Shutdown Immediate   
            Startup Mount   
            Set Until Time= ’02-Mar-2015 02:23:15’;   
            Restore Database;   
            Recover Database;  
            Alter database open resetlogs;  
        }  

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