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