3 Replies Latest reply: Dec 12, 2012 7:58 AM by Rob_J RSS

    Error in mounting the standby database

    $phinx19
      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
          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
            Mahir M. Quluzade
            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
              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