Saturday, July 16, 2016

ORA-00245: control file backup failed; target is likely on a local file system, RMAN-03009: failure of Control File and SPFILE Autobackup command, RMAN backup fail

At the time of RMAN backup, below error raise and backup fail. 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on c1 channel at 07/13/2016 11:04:09
ORA-00245: control file backup failed; target is likely on a local file system


CAUSE:
The reason for the error is clear ORA-00245 - in a RAC environment the location of the Snapshot Controlfile must be on a shared location


CURRENT:
RMAN> SHOW SNAPSHOT CONTROLFILE NAME;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name DCPDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/app/oracle/product/11.2.0.4/dbhome_1/dbs/snapcf_dcpdb1.f'; # default

RMAN>


SOLUTION:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/DCPDB/snapcf_dcpdb1.f';


CURRENT:
RMAN> SHOW SNAPSHOT CONTROLFILE NAME;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name DCPDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/DCPDB/snapcf_dcpdb1.f';

RMAN>

No comments:

Post a Comment