RMAN backup fails with Ora-00245 And Rman-08132

Symptoms

RMAN backups report errors like :

ORA-00245: control file backup operation failed

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

Cause

Incorrect specification for the Snapshot Controlfile

Solution

Incase of a RAC environment, than the Snapshot Controlfile needs to be stored on a shared location among the nodes in the RAC.

You can check the existing location for the snapshot controlfile using :

RMAN> show all;

....
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\INAM\PRODUCT\11.2.0.3\DBHOME_1\DATABASE\SNCFTESTRAC1.ORA'; # default

Especially when it is NOT explicit set, the default location is used, being $ORACLE_HOME/dbs

This directory might exist on all the related RAC-nodes, but are not necessary shared.

Depending on the configuration, the snapshot controlfile might be created on 'Node 1', but is then read on 'Node 2' as that related channel is making a backup of the controlfile.

Therefor the Snapshot Controlfile location needs to on a shared location between the nodes.

Example :

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DBDATA/SNCFTESTRAC1.ORA';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DBDATA/SNCFTESTRAC1.ORA';
new RMAN configuration parameters are successfully stored




If the location is on an NFS-filesystem, than ensure the following parameters when mounting the NFS :
rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0,noac

 Related Post:
ORA-19815: WARNING: DB_RECOVERY_FILE_DEST_SIZE 100.00% USED

Ref: 1365484.1