ESS-IRL
asked on
Crosscheck Error:ORA-19608 "is not a backup piece"
I have an Oracle database 9.2.0.6. This is backed up daily using RMAN script. I also have a scheduled job to clear off obsolete backups, basically a RMAN script with the following:
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
REPORT NEED BACKUP;
DELETE FORCE NOPROMPT OBSOLETE;
LIST BACKUP SUMMARY
I have noticed that every couple of days this now fails giving me the following error:
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 09/12/2010 21:00:09
ORA-19608: F:\BACKUP\Database\ORA_DF7 29443709_S 6959_S1 is not a backup piece
However a manual crosscheck on the backups has no issue and the scheduled task will work fine on the next night. Has anyone seen this before?
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
REPORT NEED BACKUP;
DELETE FORCE NOPROMPT OBSOLETE;
LIST BACKUP SUMMARY
I have noticed that every couple of days this now fails giving me the following error:
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 09/12/2010 21:00:09
ORA-19608: F:\BACKUP\Database\ORA_DF7
However a manual crosscheck on the backups has no issue and the scheduled task will work fine on the next night. Has anyone seen this before?
Mike,
I wonder, is it really backuppiece or Oracle managed File???
Crosscheck mark backup as "Expired" not obsolete.
I wonder, is it really backuppiece or Oracle managed File???
Crosscheck mark backup as "Expired" not obsolete.
I searched and I got this for you
http://searchoracle.techtarget.com/answer/Error-with-RMAN-cold-backup
I hope this will help you.
http://searchoracle.techtarget.com/answer/Error-with-RMAN-cold-backup
I hope this will help you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Delete command in RMAn sorted it - thanks
Try:
DELETE NOPROMPT BACKUPPIECE 'F:\BACKUP\Database\ORA_DF