This discussion is archived
8 Replies Latest reply: Jul 24, 2013 9:41 PM by user12021021 RSS

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

vivalavida Journeyer
Currently Being Moderated
Hello,

our RAC (Linux, 11.2.0.3.0) is rather new and we are still on gaining experiences with that system...

When starting the backup with RMAN we are getting the following error:

Starting Control File and SPFILE Autobackup at 04-JUL-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 07/04/2012 16:41:48
ORA-00245: control file backup failed; target is likely on a local file system

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.

When executing the RMAN command "show all" on each node, we are getting
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.3/db/dbs/snapcf_PROD021.f'; # default
for node #1
and
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.3/db/dbs/snapcf_PROD022.f'; # default
for node #2

When using a shared location for the Snapshot Controlfile do we still need to setup 2 different names for that file?

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/<shared location>/snapcf_PROD021.f'; # default
for node #1 and
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/<shared location>/snapcf_PROD022.f'; # default
for node #2

Or should we configure just one Snapshot Controlfile?

The RMAN setup for "CONFIGURE SNAPSHOT CONTROLFILE NAME TO..." must be changed on both nodes - correct?

Hopefully my question is clear enough - any help will be appreciated.

Rgds
JH

Edited by: VivaLaVida on 05.07.2012 11:41

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points