Fix RMAN-03009 ORA-00245 RMAN-08132 control file backup operation failed

Error Description: RMAN backup is getting failed with following error.

RMAN-00571: ===================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 12/15/2011 05:24:57
ORA-00245: control file backup operation failed


OR

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

Rman creates the copy of the control file as the snapshot control file for read consistency. In Oracle 11gR2 RAC database, the backup mechanism changed and all the instances may write to the snapshot controlfile. Snapshot control file must be accessible to all the instance and nodes. For Non-RAC database doesn’t make any difference.

Solution Description:
Verify your snapshot control file location. Reconfigure the snapshot control file location to a shared location using RMAN configure command.

RMAN> show all;
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/prod10/backups/prod10_snapshot_controlfile.cf';
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google