3 Replies Latest reply: Feb 27, 2013 1:33 AM by Shivananda Rao RSS

    Creating Standby on same Disk Group fails

    993614
      Hi ,

      I am configuring single node dataguard for primary RAC on same Disk Group as primary database is.Both Primary and standby access same disk group but standby node is different.I am getting below error while runing duplicate for standby from acitive database.

      The rman duplicate fails while creating standby controlfile.Below is error from rman trace file

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/27/2013 16:06:55
      RMAN-10032: unhandled exception during execution of job step 1:
      ORA-06512: at line 623
      RMAN-10035: exception raised in RPC:
      ORA-19583: conversation terminated due to error
      ORA-17628: Oracle error 19505 returned by remote Oracle server
      ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 1381
      RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


      Please let me know if it is because of same ASM disk Group.

      Regards
        • 1. Re: Creating Standby on same Disk Group fails
          CKPT
          990611 wrote:
          Hi ,

          I am configuring single node dataguard for primary RAC on same Disk Group as primary database is.Both Primary and standby access same disk group but standby node is different.I am getting below error while runing duplicate for standby from acitive database.

          The rman duplicate fails while creating standby controlfile.Below is error from rman trace file

          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/27/2013 16:06:55
          RMAN-10032: unhandled exception during execution of job step 1:
          ORA-06512: at line 623
          RMAN-10035: exception raised in RPC:
          ORA-19583: conversation terminated due to error
          ORA-17628: Oracle error 19505 returned by remote Oracle server
          ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 1381
          RMAN-10031: RPC Error: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


          Please let me know if it is because of same ASM disk Group.

          Regards
          What is the version?
          Are you suing Normal duplicate (or) using 11g ACTIVE Duplicate?

          If you are using Tapes to restore, set NB_ORA_CLIENT & NB_ORA_SERV parameter properly, refer this note RMAN backup to tape using veritas netbackup fails with RMAN-10035, ORA-27206, ORA-19583 [ID 558993.1]
          • 2. Re: Creating Standby on same Disk Group fails
            993614
            Hi,

            Thanks for reply.I am using active database duplication for standby.DB version is 11.2.0.3.

            Below is rman script

            $rman target sys/*****@abc auxiliary sys/****@xyz

            RMAN>duplicate target database for standby from active database ;

            Error occurs while running below memory script


            contents of Memory Script:
            {
            backup as copy current controlfile for standby auxiliary format '+DATA_FXX1/itssstdy/controlfile/contrl01.ctl';
            restore clone controlfile to '+DATA_FXX1/itssstdy/controlfile/contrl02.ctl' from
            '+DATA_FXX1/itssstdy/controlfile/contrl01.ctl';
            restore clone controlfile to '+DATA_FXX1/itssstdy/controlfile/contrl03.ctl' from
            '+DATA_FXX1/itssstdy/controlfile/contrl01.ctl';
            }




            Error:



            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of Duplicate Db command at 02/26/2013 23:42:07
            RMAN-05501: aborting duplication of target database
            RMAN-03015: error occurred in stored script Memory Script
            RMAN-03009: failure of backup command on C1 channel at 02/26/2013 23:42:07
            ORA-17628: Oracle error 19505 returned by remote Oracle server




            Testing:



            Commands:



            $rman target sys/*****@abc auxiliary sys/****@xyz



            rman>backup as copy current controlfile for standby auxiliary format '+DATA_FXX1/itssstdy/controlfile/contrl01.ctl';



            Same Error as above.



            But below executes succesfully.



            rman>backup as copy current controlfile for standby auxiliary format '/dbfs_direct/ITSSFX/contrl01.ctl';


            Please suggest.

            Regards
            • 3. Re: Creating Standby on same Disk Group fails
              Shivananda Rao
              Hello,

              It could be an issue with the path in the diskgroup pointing to the location where thefiles needs to be created.

              Hope these MOS documents help you !!

              *Known issues on ORA-17628: Oracle error 19505 returned by remote Oracle server Reported in Rman Active Duplicate [ID 1401333.1]*
              *Duplicate from Active Database Failing with: RMAN-03009, ORA-17628, and ORA-19505 [ID 1439632.1]*


              Regards,
              Shivananda