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



www.unisoftindia.org
  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.

Comments

  1. Harrah's Lake Tahoe - MapyRO
    Harrah's Lake 충청북도 출장마사지 Tahoe 부천 출장안마 It's a casino with the highest 여주 출장마사지 quality slots and the closest restaurants to Lake Tahoe. 강릉 출장샵 Come experience the excitement 속초 출장샵 of Lake

    ReplyDelete
  2. BetUS has wagering requirements of 30x for on line casino video games, suggesting its moderate terms and conditions. While offline gambling facilities have players crowded around roulette tables and poker tables, there isn't a|there is not any} such social pressure {when it comes to|in terms of|in relation to} 바카라 half in} online. You can play the same video games, sitting in the comfort of your own home}, enjoying live supplier interactions on chat providers.

    ReplyDelete
  3. Your possibilities of hitting it big on a low volatility slot are small comparability with} a highly volatile slot. Slot machines are video games of chance during which a Random Number Generator is quickly selecting 토토사이트 random numbers that correspond to game outcomes. You work together with the sport by wagering a bet, which supplies you the opportunity to have interaction a mechanism that instructs the sport to take a snapshot of the current random number.

    ReplyDelete

Post a Comment

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