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
Kaydol:
Kayıt Yorumları (Atom)
Hiç yorum yok:
Yorum Gönder