5 Replies Latest reply: Dec 4, 2012 10:01 AM by 977931 RSS

    ORA-19588: archived log recid 47188 stamp 693710692 is no longer valid

    715120
      Archive log backup error, the following error, how can I solve?


      sql statement: alter system archive log current

      released channel: ch00

      released channel: ch01

      allocated channel: ch00
      channel ch00: sid=3123 instance=xxtdb1 devtype=SBT_TAPE
      channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)

      allocated channel: ch01
      channel ch01: sid=3259 instance=xxtdb2 devtype=SBT_TAPE
      channel ch01: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)

      Starting backup at 01-8月 -09
      current log archived
      channel ch00: starting archive log backupset
      channel ch00: specifying archive log(s) in backup set
      input archive log thread=1 sequence=22040 recid=47183 stamp=693708892
      input archive log thread=1 sequence=22041 recid=47185 stamp=693709332
      input archive log thread=1 sequence=22042 recid=47186 stamp=693709800
      input archive log thread=1 sequence=22043 recid=47187 stamp=693710291
      channel ch00: starting piece 1 at 01-8月 -09
      channel ch01: starting archive log backupset
      channel ch01: specifying archive log(s) in backup set
      input archive log thread=2 sequence=33669 recid=47194 stamp=693732524
      input archive log thread=2 sequence=33670 recid=47195 stamp=693732528
      channel ch01: starting piece 1 at 01-8月 -09
      channel ch01: finished piece 1 at 01-8月 -09
      piece handle=al_9003_1_693732532 tag=TAG20090801T072851 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch01: backup set complete, elapsed time: 00:04:16
      channel ch01: deleting archive log(s)
      archive log filename=/arch_log2/2_33669_664512927.dbf recid=47194 stamp=693732524
      archive log filename=/arch_log2/2_33670_664512927.dbf recid=47195 stamp=693732528
      channel ch00: finished piece 1 at 01-8月 -09
      piece handle=al_9002_1_693732532 tag=TAG20090801T072851 comment=API Version 2.0,MMS Version 5.0.0.0
      channel ch00: backup set complete, elapsed time: 00:04:41
      channel ch00: deleting archive log(s)
      archive log filename=/arch_log1/1_22040_664512927.dbf recid=47183 stamp=693708892
      archive log filename=/arch_log1/1_22041_664512927.dbf recid=47185 stamp=693709332
      archive log filename=/arch_log1/1_22042_664512927.dbf recid=47186 stamp=693709800
      archive log filename=/arch_log1/1_22043_664512927.dbf recid=47187 stamp=693710291
      channel ch00: starting archive log backupset
      RMAN-03009: failure of backup command on ch00 channel at 08/01/2009 07:33:34
      ORA-19588: archived log recid 47188 stamp 693710692 is no longer valid
      channel ch00 disabled, job failed on it will be run on another channel
      released channel: ch00
      released channel: ch01
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================

      RMAN-03009: failure of backup command on ch00 channel at 08/01/2009 07:33:34
      ORA-19588: archived log recid 47188 stamp 693710692 is no longer valid

      RMAN> RMAN>

      Recovery Manager complete.

      Script /u01/oracle/products/10.2/db/scripts/full.sh
      ==== ended in error on Sat Aug 1 07:33:34 CST 2009 ====