Dataguard Configuration for XPT Services

Posted on 2006-03-28
Last Modified: 2010-08-05
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 :

      (FAILOVER=on)  (LOAD_BALANCE=off)
      (ADDRESS = (PROTOCOL = TCP)(HOST = trade_t)(PORT = 1563))
      (ADDRESS = (PROTOCOL = TCP)(HOST = trade_t_stby)(PORT = 1563))

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.

Question by:CallumT
    LVL 7

    Accepted Solution

    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.

    LVL 2

    Author Comment

    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.
    LVL 7

    Expert Comment

    Local listener in the DG should point to the Secondary Listener


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now