Perform Incomplete Recovery Until Sequence # and Thread # Using Rman in 10g and 11g

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

•  Rman > Backup Database;

3. Switch Log files.
4. Delete Some Archive logs.
5. I am doing complete recovery that time i have got an error.
6. Show error message.

•  RMAN-06025: no backup of log thread 1 seq 16 lowscn 834655 found to restore  
   RMAN-06025: no backup of log thread 1 seq 15 lowscn 834304 found to restore 

7. Some Archivelog is missing that time incomplete recovery is done.
8. Go to Rman Window and run the following command.

•  run   
      {   
        Shutdown Immediate   
        Startup Mount   
        Set Until Sequence 15 Thread 1;   
        Restore Database;   
        Recover Database;   
        Alter Database Open Resetlogs;   
      }   

9. Database only Restore sequence number 15 and after 15 and 16 sequence no all Archivelogs are available but these Archivelogs are not recoverable these all data are lost. Incomplete recovery is very Dangerous.