This discussion is archived
6 Replies Latest reply: Apr 29, 2011 7:44 AM by akm-2205195 RSS

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

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

Recovery Manager: Release - 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 .


  • Correct Answers - 10 points
  • Helpful Answers - 5 points