Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Error:
During RMAN backup, you can see the following errors.
ORA-00245: control file backup operation failed
RMAN-08132: WARNING: can not update recovery area reclaimable file list
Reason:
The directory given as the Snapshot Controlfile in RMAN configuration is not accessible from all RAC servers.
Solution:
The below settings need to be changed. This directory should be given a common directory that all servers in the RAC environment can access.
1 2 3 4 5 | RMAN > show all; ..... CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl1.f'; # default RMAN > CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/common_directory/snapcf_orcl1.f'; |
The common directory on the nfs file system should be mounted with the following parameters.
1 | rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0,noac |
