Monday, August 25, 2014

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


In case you encounter following RMAN errors

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

It's because you placed your control file backups on local disk and that's as Oracle error defines, not suitable solution RAC environment. You may check you'r current configuration by issuing
RMAN> show all; -command.

Solution for this error easy, just re-configure RMAN to place a snapshot controlfile copy to a shared location (e.g. ASM disk group):


RMAN> configure snapshot controlfile name to '+DBPROD_DATA/CONTROLFILE/snapcf_dbname.f';

or

RMAN> configure snapshot controlfile name to '+DBPROD_DATA/CLUSTER/CONTROLFILE/snapcf_dbname.f';

depending on your setup.

No comments:

Post a Comment