Keywords

ORA-00245、RMAN、Snapshot ControlFile

Applied Versions

· AnyBackup 6.0.x

Symptoms

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

Impact

AnyBackup Oracle 11g RAC database backup fails.

Cause

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.

Resolution

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:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ORADATA/ORCL/snapcf_.f';

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.