6 Replies Latest reply: Apr 23, 2013 2:32 AM by Mahir M. Quluzade RSS

    RMAN script failed while creating Data Guard 11g

    Arun Natarajan-OC
      Hi Friends,

      I am creating Physical Standby (11g) using RMAN (ACTIVE) on windows using the doc : Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE [ID 1075908.1]


      The folder structure on Primary DB and on Physical Standby is totally different.


      while executing RMAN script i got errors for lot of locations and i specified the proper location in RMAN script itself (ex set diagnostic_dest = 'c:\app\' , set db_recovery_file_dest='C:\app\flash_recovery_area')

      Location of control files on Primary DB:
      ---------------------------------------------

      D:\oradata\MESSTG\CONTROL01.CTL
      D:\oradata\flash_recovery\messtg\MESSTG\CONTROL02.CTL


      Location of control files (planned) on Physical Standby DB:
      ------------------------------------------------------------

      C:\app\oradata\MESSTDBY\CONTROL01.CTL
      C:\app\flash_recovery_area\MESSTDBY\CONTROL02.CTL


      How to specify control file location of Physical standby in set control_files?
      Also i have 2 control files on Primary DB so do i need to specify both the control files , if so how?


      I tried different combination in RMAN script but all are failed:

      set control_files='D:\oradata\MESSTG\CONTROL01.CTL','C:\app\oradata\MESSTDBY\CONTROL01.CTL'


      RMAN Error is :
      -----------------------

      while using set control_files=: C:\app\oradata\MESSTDBY\CONTROL01.CTL



      contents of Memory Script:
      {
      backup as copy current controlfile for standby auxiliary format 'D:\ORADATA\MESSTG\CONTROL01.CTL';
      restore clone controlfile to 'C:\APP\ORADATA\MESSTDBY\CONTROL01.CTL' from
      'D:\ORADATA\MESSTG\CONTROL01.CTL';
      }
      executing Memory Script

      Starting backup at 16-APR-13
      channel prmy1: starting datafile copy
      copying standby control file
      released channel: prmy1
      released channel: prmy2
      released channel: prmy3
      released channel: prmy4
      released channel: stby
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 04/16/2013 14:18:41
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-03009: failure of backup command on prmy1 channel at 04/16/2013 14:18:41
      ORA-17628: Oracle error 19505 returned by remote Oracle server

      RMAN>



      Error 2)
      ----------------

      while using set control_files='D:\oradata\MESSTG\CONTROL01.CTL','C:\app\oradata\MESSTDBY\CONTROL01.CTL'


      contents of Memory Script:
      {
      backup as copy current controlfile for standby auxiliary format 'D:\ORADATA\MESSTG\CONTROL01.CTL';
      }
      executing Memory Script

      Starting backup at 16-APR-13
      channel prmy1: starting datafile copy
      copying standby control file
      released channel: prmy1
      released channel: prmy2
      released channel: prmy3
      released channel: prmy4
      released channel: stby
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 04/16/2013 13:22:33
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-03009: failure of backup command on prmy1 channel at 04/16/2013 13:22:33
      ORA-17628: Oracle error 19505 returned by remote Oracle server

      RMAN>

      Regards,
      DB