2 Replies Latest reply: Dec 27, 2012 7:59 AM by Pinela RSS

    Recovery when 1 of the redo log is missing

    user2015671
      I am using below procedure to recover redo log files when all the redo log are missing.

      ================================================
      Question:Do i need to follow same procedure when 1 of the redo log is missing?
      ================================================

      RMAN> run {
      set until sequence 54;
      restore database;
      recover database;
      alter database open resetlogs;
      }
      2> 3> 4> 5> 6>
      executing command: SET until clause

      Starting restore at 25-DEC-12
      using channel ORA_DISK_1

      channel ORA_DISK_1: starting datafile backup set restore
      channel ORA_DISK_1: specifying datafile(s) to restore from backup set
      channel ORA_DISK_1: restoring datafile 00001 to /qa/data/obt/QA112QA/data/system01.dbf
      channel ORA_DISK_1: restoring datafile 00002 to /qa/data/obt/QA112QA/data/sysaux01.dbf
      channel ORA_DISK_1: restoring datafile 00003 to /qa/data/obt/QA112QA/data/rbs01.dbf
      channel ORA_DISK_1: restoring datafile 00004 to /qa/data/obt/QA112QA/data/temp01.dbf
      channel ORA_DISK_1: restoring datafile 00005 to /qa/data/obt/QA112QA/data/tools01.dbf
      channel ORA_DISK_1: restoring datafile 00006 to /qa/data/obt/QA112QA/data/users01.dbf
      channel ORA_DISK_1: restoring datafile 00007 to /qa/data/obt/QA112QA/data/vindx.dbf
      channel ORA_DISK_1: restoring datafile 00008 to /qa/data/obt/QA112QA/data/incre1.dbf
      channel ORA_DISK_1: restoring datafile 00009 to /qa/data/obt/QA112QA/data/rman_tbs.dbf
      channel ORA_DISK_1: reading from backup piece /qa/data/obt/rmanbackup/01ntofrc_1_1
      channel ORA_DISK_1: piece handle=/qa/data/obt/rmanbackup/01ntofrc_1_1 tag=LEVEL0BACKUP
      channel ORA_DISK_1: restored backup piece 1
      channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
      Finished restore at 25-DEC-12

      Starting recover at 25-DEC-12
      using channel ORA_DISK_1

      starting media recovery

      archived log for thread 1 with sequence 53 is already on disk as file /qa/data/obt/QA112QA/admin/arch/1_53_802911384.log
      channel ORA_DISK_1: starting archived log restore to default destination
      channel ORA_DISK_1: restoring archived log
      archived log thread=1 sequence=51
      channel ORA_DISK_1: restoring archived log
      archived log thread=1 sequence=52
      channel ORA_DISK_1: reading from backup piece /qa/data/obt/rmanbackup/03ntofs3_1_1
      channel ORA_DISK_1: piece handle=/qa/data/obt/rmanbackup/03ntofs3_1_1 tag=TAG20121225T132211
      channel ORA_DISK_1: restored backup piece 1
      channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
      archived log file name=/qa/data/obt/QA112QA/admin/arch/1_51_802911384.log thread=1 sequence=51
      archived log file name=/qa/data/obt/QA112QA/admin/arch/1_52_802911384.log thread=1 sequence=52
      archived log file name=/qa/data/obt/QA112QA/admin/arch/1_53_802911384.log thread=1 sequence=53
      media recovery complete, elapsed time: 00:00:01
      Finished recover at 25-DEC-12

      database opened
      new incarnation of database registered in recovery catalog
      starting full resync of recovery catalog
      full resync complete

      RMAN>