Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Dataguard Configuration for XPT Services

Posted on 2006-03-28
5
Medium Priority
?
2,553 Views
Last Modified: 2010-08-05
Hi,
I am attempting to configure a Dataguard environment which utilises connect  time failover, so during a Switchover scenario, clients are able to connect to the New Primary without the need for reconfiguring DNS or change TNSNAMES.ORA on client-side. However in doing so, we can't ship logs back to the Old primary (see below)

So, in the TNSNAMES.ora file we have :

TRADE_T.CONTACT-ENERGY.CO.NZ =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (FAILOVER=on)  (LOAD_BALANCE=off)
      (ADDRESS = (PROTOCOL = TCP)(HOST = trade_t)(PORT = 1563))
      (ADDRESS = (PROTOCOL = TCP)(HOST = trade_t_stby)(PORT = 1563))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TRADE_T.contact-energy.co.nz)
    )
  )

The idea being that during a SWITCHOVER situation we close the old Primary Listener, therefore closing all connections to the OLD Primary (trade_t). However, as the trade_t_xpt service has registered with the TRADE_T listener, it can't ship logs back from the new primary (trade_t_stby) to the new standby (trade_t).

The actual switchover (and failovers) are working fine.It's just that I want a configuration taht requires a change to DNS or mods to the client tnsnames.ora during any switchover.

0
Comment
Question by:CallumT
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
vishal68 earned 2000 total points
ID: 16319194
One way of handling it can be to use two listeners on the primary site. One listener is the main trade_t listener on which the users login. Create another listener (maybe called trade_t2) and register the trade_t_xpt service with the new listener. This way during the SWITCHOVER, you can shutdown the trade_t listener, no user will be able to login, but keep the second listener (trade_t2) up and runnig, so that the logs can be shipped back to the new standby.

HTH
Vishal
 
0
 
LVL 2

Author Comment

by:CallumT
ID: 16376016
Thanks That did the trick. Although having a few issues with the DataGuard Broker, should the locallistener paremeter in a DG Database configuration point to the Main Listener or the Secondary (XPT) listener.
0
 
LVL 7

Expert Comment

by:vishal68
ID: 16379268
Local listener in the DG should point to the Secondary Listener

HTH
Vishal
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question