Q

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 piece
Then 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 directory
Additional information/questions:
  1. Is my backup method valid?
  2. Is that backup piece corrupt which is showing the error?
  3. I am taking a cold backup daily.
Please help me.
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.
This was first published in December 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close