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:



So, it is better not to use db_%I-%d-%T-%s-%p-%c format during backup. Use just %U, it is qute enough.
Or do not use _ character after db, use just -.

Script to rename:

for i in $(ls -1 -t local-*|egrep "db_|al_|ccf_|spf_"); do _TMP=$(echo $i|sed 's/_/-/g'); echo "mv $i $_TMP"; done >rename.cmd

But nothing above does work!

Actual Solution from metalink RMAN Restore Fails: ORA-19870 ORA-19587 ORA-27091 ORA-27067 RMAN-06026 RMAN-06023 Doc ID 429689.1:
Make the RMAN backuppiece not only readable but also writable. See bug 5412531 for other details.



No comments:

Post a Comment