8 Replies Latest reply: Jul 24, 2013 11:41 PM by user12021021 RSS

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

    vivalavida
      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