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
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