Home » Server Options » Data Guard » Data Guard, TAF, and switchover
Data Guard, TAF, and switchover [message #181808] Tue, 11 July 2006 11:54 Go to next message
Messages: 4
Registered: June 2006
Location: Dallas / Fort Worth, TX
Junior Member

(Oracle on AIX 5.2)

After extensive reading on Oracle's site as well as this forum, what remains unclear to me is access to the standby database prior to the manual switchover is performed.

My understanding is:

There will be two entries in tnsnames (if only one Standby) and if the Primary database is deemed down or inaccessable then the applications connect to the Standby database in a "read-only" mode by the second entry in tnsnames.

The Standby will continue to serve SELECT statements but not be capable of create/update/delete statements until it has been made Primary via Data Guard switchover.

Is this an accurate understanding of the capabilities & functionality of Data Guard with TAF?

(My objective is to eliminate the need to push a new tnsnames to Application Servers and then have to cycle the JVM's.)
Re: Data Guard, TAF, and switchover [message #191492 is a reply to message #181808] Wed, 06 September 2006 10:42 Go to previous message
Messages: 121
Registered: August 2006
Senior Member
Physical standby can be either in "managed recovery" mode or "read only" mode.

What protection mode are you using for your standby setup.

Previous Topic: Replication Times
Next Topic: Data Guard on ASM
Goto Forum:

Current Time: Wed Mar 03 05:07:10 CST 2021