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:
Showing posts with label RMAN-03002. Show all posts
Showing posts with label RMAN-03002. Show all posts
Monday, February 21, 2011
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...
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...
Subscribe to:
Posts (Atom)