Disaster Recovery config.

[Former Member]

Hi All,

Our production server ECC6.0 runs on Windows 2003 with MCSC configuration. I need to do a Disaster Recovery configuration with Oracle Data Guard. The DR server will be located on a different location. I have read a few documents on DR configuration, it says that we need to modifiy the Listener.ora and TNSnames.org.

Has anyone done this before using Oracle Data Guard? If so, please explain me how to configure both the files.

Many Thanks,

Bala

[Former Member]

Hi,

Good documentation related to data guard

http://onlineappsdba.com/index.php/2008/05/19/configugre-oracle-data-guard-part-ii/

regards,

Srinivas

[Former Member]

Hi,

Thanks for providing the link. Now am stuck up with the listener and TNSNAMES.ORA file configuration. Can anyone help me out in configuring these files for data guard.

My LISTENER.ora file contents are:

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = TQS.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = TQS)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = tejsapdr)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = TQS)

(ORACLE_HOME = E:\oracle\TQS\102)

)

)

TNSNAMES.ora files contents are:

################

TQS.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = sapqa)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = TQS)

(GLOBAL_NAME = TQS.WORLD)

)

)

Regards,

Bala

[stefan_koehler]

Hello Bala,

just follow these two Metalinknotes:

 736863.1 - Steps To Create Physical Standby Database
 745201.1 - Diagnosing Connection Problems with an active Data Guard Broker Configuration

It also depends on if you use the Oracle Data Guard Broker or not. So please read especially the Metalinknote #736863.1 and follow it step by step (including listener.ora / tnsnames.ora configuration).

Metalinknote #745201.1 is just for information.

Regards

Stefan

[Former Member]

Hi ,

Good documents

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76995/standbyc.htm#30150