Problem solve
Get help with specific problems with your technologies, process and projects.
Error with RMAN cold backup
I am taking a cold backup through RMAN. Yesterday I ran a crosscheck command and got this error. Is my backup method valid?
I have a query. I am taking a cold backup through RMAN. Yesterday I ran a crosscheck command and got this error:
RMAN> CROSSCHECK BACKUP; allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=49 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=96 devtype=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: sid=37 devtype=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: sid=98 devtype=DISK allocated channel: ORA_DISK_5 channel ORA_DISK_5: sid=74 devtype=DISK crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/orabackup/rman/control/c-4124556498- 20061027-00 recid=1997 stamp=604955892 RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 11/11/2006 14:34:11 ORA-19608: /orabackup/rman/control/c-4124556498- 20061028-00 is not a backup pieceThen I ran:
RMAN> RESTORE DATABASE VALIDATE; Starting restore at 11-NOV-06 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 using channel ORA_DISK_5 channel ORA_DISK_1: starting validation of datafile backupset channel ORA_DISK_2: starting validation of datafile backupset channel ORA_DISK_3: starting validation of datafile backupset channel ORA_DISK_4: starting validation of datafile backupset channel ORA_DISK_5: starting validation of datafile backupset RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03002: failure of restore command at 11/11/2006 14:35:14 ORA-19505: failed to identify file "/orabackup/rman/data/10NOV2006_8qi22lel_1_1_20061110_%S.bak" ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directoryAdditional information/questions:
- Is my backup method valid?
- Is that backup piece corrupt which is showing the error?
- I am taking a cold backup daily.
When your crosscheck fails, the first thing I do is to make sure that I get a good backup of the database. Once I have that backup, I no longer need the backup piece that caused the crosscheck to fail. The next thing to do is to tell RMAN that the backup piece no longer exists. This is done with the DELETE command in RMAN.
