issues with creating standby database with rman
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: issues with creating standby database with rman

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    issues with creating standby database with rman

    DBAs,

    I tried to use rman to create a standby database to the remote server. The primary database is on oracle 9.2.
    The primary and the standby databases have different names.
    primary: odewk standbyyewk

    I followed the instructions to create the standby controlfile:
    COPY CURRENT CONTROLFILE FOR STANDBY TO ....

    But when I issued the :
    ORA-01103: database name 'ODEWK' in controlfile is not 'OYEWK'

    Does that mean the standby must have the same name as the primary database?

    FYI: the following is the whole output

    DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK DORECOVER;

    I got the following errors:

    RMAN> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK DORECOVER;

    Starting Duplicate Db at 05-JAN-06
    allocated channel: ORA_AUX_DISK_1
    channel ORA_AUX_DISK_1: sid=15 devtype=DISK

    printing stored script: Memory Script
    {
    restore clone standby controlfile to clone_cf;
    replicate clone controlfile from clone_cf;
    sql clone 'alter database mount standby database';
    }
    executing script: Memory Script

    Starting restore at 05-JAN-06

    using channel ORA_AUX_DISK_1
    channel ORA_AUX_DISK_1: restoring controlfile
    output filename=/db01/oradata/OYEWK/control/OYEWK_01.ctl
    channel ORA_AUX_DISK_1: copied controlfile copy
    input filename=/tmp/ODEWK_01.ctl
    output filename=/db01/oradata/OYEWK/control/OYEWK_01.ctl recid=0 stamp=0
    Finished restore at 05-JAN-06

    replicating controlfile
    input filename=/db01/oradata/OYEWK/control/OYEWK_01.ctl
    output filename=/db02/oradata/OYEWK/control/OYEWK_02.ctl
    output filename=/db03/oradata/OYEWK/control/OYEWK_03.ctl

    sql statement: alter database mount standby database
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of Duplicate Db command at 01/05/2006 15:37:06
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-03009: failure of sql command on clone_default channel at 01/05/2006 15:37:06
    RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
    ORA-01103: database name 'ODEWK' in controlfile is not 'OYEWK'


    Thanks,

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Your parameter file does not match with the control file. Make sure the parameter file is fixed first, and your service name strings are correct.

    Thanx
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thanks for the reply.
    I found my mistake. The db_name in the standby's init file should be the same as the primary database.
    After fixing this, everything went fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width