Hi,
I recevied below error in Exadata RAC database.
ORA-00245: control file backup failed; target is likely on a local file system
As per metalink Note 1472171.1 In RAC environment from 11.2 onwards Backup Or Snapshot control file needs to be in shared location.
If shared disk:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<Shared_Location>/DB1ORCL.g';
If ASM:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<+DiskGroup>/DB1ORCL.g';
When I checked in Rman, I could see the below. Looks like snapshot control file is already configured to shared disk. But don't know why I am getting this ORA error.
Could you please check and suggest how to fix this issue?
RMAN> show snapshot controlfile name;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name BQ2 are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA_DM01/BP3SM/snapcfBP3.dbf';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA_DM01/bp3sm/snapcfbp3.dbf';
This is Exadata server
This is RAC database.
Oracle - 11.2.0.4.0
OS -- Linux
This is prod.
Regards,
Bala