2 Replies Latest reply on Apr 24, 2013 1:45 AM by Hemant K Chitale

    RMAN - specification does not match any archived log in the repository

    MSandico
      Hi All,

      Oracle 11G R2 on WIndows woo8 R2 Std Edition

      I am running RMAN (almost for the first time), and i am using a script previously used. As i am checking through the log, i notice some 'errors' though the backup finishes successfully.
      RMAN> crosscheck archivelog all;
      
      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=352 device type=DISK
      specification does not match any archived log in the repository
      
      RMAN> crosscheck backupset;
      
      using channel ORA_DISK_1
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_NCNNF_TAG20130423T134331_8QFL24F7_.BKP RECID=16 STAMP=813505412
      
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_ANNNN_TAG20130423T134334_8QFL26K1_.BKP RECID=17 STAMP=813505414
      
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_NCNNF_TAG20130423T134423_8QFL3S48_.BKP RECID=18 STAMP=813505465
      
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_ANNNN_TAG20130423T134427_8QFL3V9J_.BKP RECID=19 STAMP=813505467
      
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_NNNDF_TAG20130423T134428_8QFL3XDT_.BKP RECID=20 STAMP=813505469
      
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_NCSNF_TAG20130423T134428_8QFM4C5S_.BKP RECID=21 STAMP=813506507
      
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=D:\ORACLE\DATABASE\ORADATA\MMSPRD7\ORAFRA\MMSPRD7\BACKUPSET\
      2013_04_23\O1_MF_ANNNN_TAG20130423T140148_8QFM4DOT_.BKP RECID=22 STAMP=813506508
      
      Crosschecked 7 objects
      
      
      RMAN> crosscheck copy;
      
      released channel: ORA_DISK_1
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=352 device type=DISK
      specification does not match any datafile copy in the repository
      specification does not match any control file copy in the repository
      specification does not match any archived log in the repository
      So there are 2 instances of the errors:

      1) crosscheck archivelog all - when the error happens here, i think this means that there are no archived redo logs in the archivelog destination?? ..or something to that nature.

      2) crosscheck copy - not sure what the other errors mean here.

      Thx in advance!