RMAN : ORA-00245: control file backup operation failed

Problem

The RMAN backup of a database in RAC environnement fails with the error: ORA-00245: control file backup operation failed.

 

Solution

What is a snapshot controlfile  ?

A snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly.

The snapshot controlfile must be on a location shared by all RAC nodes in a cluster (it must be accessable by all nodes on which instances for an RAC database can run).

 

 

RMAN> show all;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/apps/oracle/11202/rdb/rac/dbs/snapcf_MY_DB.f'; # default

 

 

1 . Find a shared location

for example : +DGDATA/MY_DB/CONTROLFILE/

 

2. Change the location
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DGDATA/MY_DB/CONTROLFILE/snapcf_MY_DB.f';