25 Ağustos 2014 Pazartesi

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



PROBLEM:
---------------------

executing command: SET COMMAND ID
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script cdtprod_backup_arch
RMAN-03002: failure of set command at 08/24/2014 21:38:42
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/24/2014 21:38:42
ORA-00245: control file backup failed; target is likely on a local file system





SOLUTION:
------------------

The controlfile is shared on RAC database and having the backup from anyone node to the shared mountpoint would meet the requirement.

configure snapshot controlfile name to '/<shared location>/snapcf_NEPRO0.f';


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.


Example:
-------

before
-------
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_NEPRO1.f'; # default


after:
-------

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/NEPRO/snapcf_NEPRO1.f'; # default

Hiç yorum yok:

Yorum Gönder