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
poconojohnny
Messages: 4
Registered: June 2006
Location: Dallas / Fort Worth, TX
Junior Member

(Oracle 9.2.0.6 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
email.sandeepnaik
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.

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


Current Time: Thu Mar 28 23:59:55 CDT 2024