2 Replies Latest reply: Nov 11, 2012 6:45 AM by Venkadesh Raja RSS

    Error while Restore.

    Venkadesh Raja
      Hi Experts.

      i take database backup.
      MAN> backup database plus archivelog;
      
      
      Starting backup at 11-NOV-12
      using channel ORA_DISK_1
      specification does not match any archive log in the recovery catalog
      backup cancelled because all files were skipped
      Finished backup at 11-NOV-12
      
      Starting backup at 11-NOV-12
      using channel ORA_DISK_1
      channel ORA_DISK_1: starting full datafile backupset
      channel ORA_DISK_1: specifying datafile(s) in backupset
      input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSTEM01.DBF
      
      input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSAUX01.DBF
      
      input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\EXAMPLE01.DB
      F
      input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\UNDOTBS01.DB
      F
      input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF
      channel ORA_DISK_1: starting piece 1 at 11-NOV-12
      channel ORA_DISK_1: finished piece 1 at 11-NOV-12
      piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2012_11
      _11\O1_MF_NNNDF_TAG20121111T170118_89Z347K4_.BKP tag=TAG20121111T170118 comment=
      NONE
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
      channel ORA_DISK_1: starting full datafile backupset
      channel ORA_DISK_1: specifying datafile(s) in backupset
      including current control file in backupset
      including current SPFILE in backupset
      channel ORA_DISK_1: starting piece 1 at 11-NOV-12
      channel ORA_DISK_1: finished piece 1 at 11-NOV-12
      piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2012_11
      _11\O1_MF_NCSNF_TAG20121111T170118_89Z36119_.BKP tag=TAG20121111T170118 comment=
      NONE
      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:06
      Finished backup at 11-NOV-12
      
      Starting backup at 11-NOV-12
      using channel ORA_DISK_1
      specification does not match any archive log in the recovery catalog
      backup cancelled because all files were skipped
      Finished backup at 11-NOV-12
      When i try to restore my controlfile it's showing error like
      RMAN> restore controlfile from 'O1_MF_NCSNF_TAG20121111T170118_89Z36119_';
      
      Starting restore at 11-NOV-12
      using channel ORA_DISK_1
      
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 11/11/2012 17:23:14
      RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
      Pls Help i dono where i'm going Wrong..