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

Creating Standby on same Disk Group fails

993614 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

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