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: Oracle 9i Data guard
Next Topic: The primary DB stopped when the standby datbase failed
Goto Forum:

Current Time: Sat Aug 19 06:25:38 CDT 2017

Total time taken to generate the page: 0.01262 seconds