| Data Guard, TAF, and switchover [message #181808] |
Tue, 11 July 2006 11:54  |
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.)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
