dataguard

init.ora : primary
##########################################################################
# 2010.11.24  Standby database Configuration                             #
##########################################################################
log_archive_config='DG_CONFIG=(M11MES,M11MES_STB)'
log_archive_dest_2='SERVICE=M11MES_STB VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=M11MES_STB LGWR ASYNC NOAFFIRM DELAY=
60 REOPEN=10'

Tnsnames.ora : primary
M11MES_STB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = m11mesd2_vip)(PORT = 1525))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = M11MES)
      (INSTANCE_NAME = M11MES_STB)
    )
  )

init.ora : standby
###########################################
# Configuration for DataGuard
###########################################

###--- COMMON TO BOTH PRIMARY AND STANDBY ROLES ---###
LOG_ARCHIVE_CONFIG='DG_CONFIG=(M11MES,M11MES_STB)'

## if modify, note that TINA has a Length checking problem on LOG_ARCHIVE_DEST_1
LOG_ARCHIVE_DEST_1='LOCATION=/messarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=M11MES_STB'

##Maximum Performance##
##LOG_ARCHIVE_DEST_2='SERVICE=M11MES_STB
##                    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
##                    DB_UNIQUE_NAME=M11MES_STB
##                    LGWR ASYNC DELAY=60 REOPEN=10'

##Maximum Availability##
##LOG_ARCHIVE_DEST_2='SERVICE=M11MES_STB
##                    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
##                    DB_UNIQUE_NAME=M11MES_STB
##                    LGWR SYNC AFFIRM DELAY=60 REOPEN=10 NET_TIMEOUT=10'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
log_archive_format=m11mes_%t_%s_%r.arc

###--- SPECIFIC TO STANDBY ROLE ---###
STANDBY_FILE_MANAGEMENT=AUTO
STANDBY_ARCHIVE_DEST='/messarch'
FAL_SERVER=M11MES1
FAL_CLIENT=M11MES_PHYSTB
DB_FILE_NAME_CONVERT=('/dev/vgpmes11','/dev/vgsmes11',
                      '/dev/vgpmes12','/dev/vgsmes12',
                      '/dev/vgpmes13','/dev/vgsmes13',
                      '/dev/vgpmes14','/dev/vgsmes14')
LOG_FILE_NAME_CONVERT=('/dev/vgpmes11','/dev/vgsmes11',
                       '/dev/vgpmes12','/dev/vgsmes12',
                       '/dev/vgpmes13','/dev/vgsmes13',
                       '/dev/vgpmes14','/dev/vgsmes14')

Tnsnames.ora : standby
LISTENER_M11MES_STB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = m11mesd2_vip)(PORT = 1525))
  )

M11MES_PHYSTB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = m11mesd2_vip)(PORT = 1525))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = M11MES)
      (INSTANCE_NAME = M11MES_STB)
    )
  )

M11MES2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = m11mesd2_vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = M11MES)
      (INSTANCE_NAME = M11MES2)
    )
  )

M11MES1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = m11mesd1_vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = M11MES)
      (INSTANCE_NAME = M11MES1)
    )
  )

listener.ora : standby
# listener.ora.m11mesd2 Network Configuration File: /mespora/app/oracle/product/10.2.0/network/admin/listener.ora.m11mesd2
# Generated by Oracle configuration tools.

LISTENER_M11MES_STB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = m11mesd2_vip)(PORT = 1525)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 177.97.11.23)(PORT = 1525)(IP = FIRST))
      )
    )
  )

SID_LIST_LISTENER_M11MES_STB =
  (SID_LIST =
    (SID_DESC =
      (GLBAL_DBNAME = M11MES)
      (ORACLE_HOME= /messora/app/oracle/product/10.2.0)
      (SID_NAME = M11MES_STB)
    )
  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_M11MES_STB = OFF
INBOUND_CONNECT_TIMEOUT_LISTENER_M11MES_STB=0