6 Replies Latest reply: Apr 29, 2011 9:44 AM by akm-2205195 RSS

    catalog backupiece failed with errror ORA-19870,ORA-19505,ORA-27037

    akm-2205195
      dicgws01:>rman target sys/****@dmzdbprd catalog rman/***@rcatalog auxiliary /

      Recovery Manager: Release 10.2.0.5.0 - Production on Fri Apr 29 15:00:23 2011

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      connected to target database: DMZDBPRD (DBID=2467746703)
      connected to recovery catalog database
      connected to auxiliary database: DMZDBPRD (not mounted)

      RMAN> CATALOG BACKUPPIECE '/rms_data2/backup/ucmattsg_1_1';

      ORA-19870: error reading backup piece /rms_data2/backup/ucmattsg_1_1
      ORA-19505: failed to identify file "/rms_data2/backup/ucmattsg_1_1"
      ORA-27037: unable to obtain file status
      HPUX-ia64 Error: 2: No such file or directory
      Additional information: 3
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of catalog command at 04/29/2011 15:00:52
      RMAN-06209: List of failed objects
      RMAN-06211: ==========================
      RMAN-06212: Object Type Filename/Handle
      RMAN-06213: --------------- ---------------------------------------------------
      RMAN-06214: Backup Piece /rms_data2/backup/ucmattsg_1_1



      dicgws01:>ls -ltr /rms_data2/backup/ucmattsg_1_1
      -rwxrwxr-x 1 oracle dba 7700480 Apr 28 16:28 /rms_data2/backup/ucmattsg_1_1

      backup availabele on DR server but still unable to catalog it.please help me .