Perform Incomplete Recovery Until Scn No.Using Rman in 10g and 11g

1. First Database in Archivelog Mode.
2. Take Rman Backup.

•    Rman > Backup Database;   

3. Take a current scn no first time.

•     Sql > Select timestamp_to_scn(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 timestamp_to_scn(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 Scn < Scn_No >;   
           Restore Database;   
           Recover Database;   
           Alter Database Open Resetlogs;   
         }   

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