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.


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

Oracle Database SQL - Practise - Question - Scott Schema Examples