This discussion is archived
3 Replies Latest reply: Dec 12, 2012 5:58 AM by Rob_J RSS

Error in mounting the standby database

$phinx19 Newbie
Currently Being Moderated
Hi All,

OS:Solaris
DB:10G

I am facing the below mentioned error while i am trying to create a standby database on the same server.

Following are the steps that i have followed for the same.

1.Checked the connectivity.
2.Created the pfile for primary DB as mentioned below:
*.DB_BLOCK_SIZE=8192
*.OPEN_CURSORS=300
*.CURSOR_SHARING=FORCE
*.BACKGROUND_DUMP_DEST='/11g/oradata/admin/ettest/bdump'
*.CORE_DUMP_DEST='/11g/oradata/admin/ettest/cdump'
*.USER_DUMP_DEST='/11g/oradata/admin/ettest/udump'
*.CONTROL_FILES=("/11g/oradata/admin/data/controlfiles/control01.ctl","/11g/oradata/admin/data/controlfiles/control02.ctl")
*.DB_NAME=ettest
*.PROCESSES=150
*.UNDO_MANAGEMENT=AUTO
*.UNDO_TABLESPACE=undotbs
*.compatible='10.2.0.1.0'
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.LOG_ARCHIVE_DEST_1='Location=/11g/oradata/archives/'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.DB_FILE_NAME_CONVERT='/11g/oradata/admin/data/datafiles/','/11g/oradata_dr/ettestdr/datafiles/'
*.LOG_FILE_NAME_CONVERT='/11g/oradata/admin/data/logfiles/','/11g/oradata_dr/ettestdr/redologs/'
*.STANDBY_ARCHIVE_DEST='/11g/oradata_dr/ettestdr/dr_archives/ettestdr'
*.LOG_ARCHIVE_DEST_2='SERVICE=ettestdr'
*.FAL_SERVER='ETTESTDR'
*.FAL_CLIENT='ETTEST'

3. Created the pfile for DR:

*.DB_UNIQUE_NAME=ettestdr
*.DB_BLOCK_SIZE=8192
*.OPEN_CURSORS=300
*.CURSOR_SHARING=FORCE
*.BACKGROUND_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/bdump'
*.CORE_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/cdump'
*.USER_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/udump'
*.CONTROL_FILES=("/11g/oradata_dr/ettestdr/controlfiles/standbycontrolfile.ctl")
*.DB_NAME=ettestdr
*.PROCESSES=150
*.UNDO_MANAGEMENT=AUTO
*.UNDO_TABLESPACE=undotbs
*.compatible='10.2.0.1.0'
*.FAL_SERVER='ETTEST'
*.FAL_CLIENT='ETTESTDR'
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.LOG_ARCHIVE_DEST_1='Location=/11g/oradata/archives/'
*.STANDBY_ARCHIVE_DEST='/11g/oradata_dr/ettestdr/dr_archives/ettestdr'
*.LOG_ARCHIVE_DEST_2='SERVICE=ettestdr'
*.LOG_ARCHIVE_DEST_STATE_2='DEFER'
*.DB_FILE_NAME_CONVERT='/11g/oradata_dr/ettestdr/datafiles/','/11g/oradata/admin/data/datafiles/'
*.LOG_FILE_NAME_CONVERT='/11g/oradata_dr/ettestdr/redologs/','/11g/oradata/admin/data/logfiles/'

4.In the mean time i have backed up the database and transferd the same on the DR location and then i ahve created the standbycontrolfiel using the command on priamary server with sys login using the command:
alter databse create standby controlfile as '/path';
5.My Primary was up using the said pfile.
6.I was also able to put my DR in nomount stage using the above pfile
7.I transfered the controlfile at the appropriate location of the DR server and when i am trying to mount the DR db using:
alter database mount standby database;
I am getting the below mentioned error
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01103: database name 'ETTEST' in control file is not 'ETTESTDR'
Kindly suggest...
BR
Sphinx

Edited by: $phinx19 on Dec 12, 2012 5:29 AM
  • 1. Re: Error in mounting the standby database
    P.Forstmann Guru
    Currently Being Moderated
    Try to modify in standby init. file:
    DB_NAME=ETTEST
    Edited by: P. Forstmann on 12 déc. 2012 14:36
  • 2. Re: Error in mounting the standby database
    MahirM.Quluzade Guru
    Currently Being Moderated
    Hi,

    You must create pfile for Standby side with parameter DB_UNIQUE_NAME = ettestdr but DB_NAME is same with primary as DB_NAME = ettest.
    *.DB_UNIQUE_NAME=ettestdr
    *.DB_BLOCK_SIZE=8192
    *.OPEN_CURSORS=300
    *.CURSOR_SHARING=FORCE
    *.BACKGROUND_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/bdump'
    *.CORE_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/cdump'
    *.USER_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/udump'
    *.CONTROL_FILES=("/11g/oradata_dr/ettestdr/controlfiles/standbycontrolfile.ctl")
    *.DB_NAME=ettest
    *.PROCESSES=150
    *.UNDO_MANAGEMENT=AUTO
    *.UNDO_TABLESPACE=undotbs
    *.compatible='10.2.0.1.0'
    *.FAL_SERVER='ETTEST'
    *.FAL_CLIENT='ETTESTDR'
    *.STANDBY_FILE_MANAGEMENT='AUTO'
    *.LOG_ARCHIVE_DEST_1='Location=/11g/oradata/archives/'
    *.STANDBY_ARCHIVE_DEST='/11g/oradata_dr/ettestdr/dr_archives/ettestdr'
    *.LOG_ARCHIVE_DEST_2='SERVICE=ettest'
    *.LOG_ARCHIVE_DEST_STATE_2='DEFER'
    *.DB_FILE_NAME_CONVERT='/11g/oradata_dr/ettestdr/datafiles/','/11g/oradata/admin/data/datafiles/'
    *.LOG_FILE_NAME_CONVERT='/11g/oradata_dr/ettestdr/redologs/','/11g/oradata/admin/data/logfiles/' 
    And in pfile for standby *.LOG_ARCHIVE_DEST_2='SERVICE=ettest' - after switchover logs transport to primary (ettest)

    Regards
    Mahir M. Quluzade
    www.mahir-quluzade.com

    Edited by: Mahir M. Quluzade on Dec 12, 2012 5:44 PM
  • 3. Re: Error in mounting the standby database
    Rob_J Journeyer
    Currently Being Moderated
    Hello,

    Here are some notes on the exact steps I have used to [url http://ora00600.com/articles/data-guard-physical-standby-upgrade.html] create a physical standby database .

    Start from the heading "Guide to Creating and Configuring a Physical Standby Database with Data Guard" if you aren't interested in the first part.

    Hope that helps,
    Rob

Legend

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