Showing posts with label RMAN-03002. Show all posts
Showing posts with label RMAN-03002. Show all posts

Monday, February 21, 2011

no backup or copy of datafile XX found to restore when backup actually exists

Attempting to restore catalogued backup on another host gives following error:

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-FEB-11

released channel: ch01
released channel: ch02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/20/2011 20:35:40
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile XX1 found to restore
RMAN-06023: no backup or copy of datafile XX2 found to restore

but when I did list backup, it shown backup exist.

Erorr was the consequence of  catalog command. There was attempt to catalog backupset with dificult name like /mnt/share/backup/oracle/DBNAME/local-lvl-0-db_3673504914-DB01-20110220-38400-1-1 which catalog was not able to compile.
solution:

Tuesday, December 1, 2009

ORA-19573: cannot obtain exclusive enqueue for datafile during standby refresh from primary

Problem:
RMAN> RECOVER DATABASE NOREDO;

but I got an error:
RMAN-03002: failure of recover command at 12/01/2009 11:04:15
ORA-19870: error reading backup piece /oracle/rbackup.moon/ForStandby_2rkvqc1o_1_1
ORA-19573: cannot obtain exclusive enqueue for datafile 2

Description:
Unexpected ORA-XXX during refresh standby operation caused by 'RECOVER MANAGED STANDBY'


Solution:
SQLPLUS>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
RMAN> RECOVER DATABASE NOREDO;
enjoy...