AnyBackup- Oracle 11g RAC database backup fails with Oracle error code ORA-00245

2020-06-28 608 0


ORA-00245RMANSnapshot ControlFile


Applied Versions

· AnyBackup 6.0.x



In AnyBackup, when you try to backup Oracle 11g RAC database, it fails. And under Execution Output window, you can see the errors:

ORA-00245: control file backup failed; target is likely on a local file system



AnyBackup Oracle 11g RAC database backup fails.



Since Oracle 11g R2, the backup mechanism of control file has changed. Snapshot ControlFile is required to be visible to all instances. In RAC environment, error code ORA-00245 will be occasionally encountered if the Snapshot ControlFile is not in the shared storage path.



To resolve this issue, change the storage path of Oracle database Snapshot ControlFile to shared storage.

1.    Go to RMAN, check the parameter Snapshot ControlFile. Execute the command below:

show snapshot controlfile name;


2.    Configure the parameter Snapshot ControlFile, change the storage path of Oracle database Snapshot ControlFile to shared storage. Execute the command below:


Note: +ORADATA/ORCL/ is the shared storage path for Oracle RAC.

3.    Start the oracle backup job again on AnyBackup console.


More Information

For more information about the error code ORA-00245, please refer to the Oracle official article: Oracle Error Code Query. & Korea)