RE: Question for Dataguard users
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'RStorey@xxxxxxxxxxxxxxxxxx'" <RStorey@xxxxxxxxxxxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2011 11:07:52 -0700
Primary tnsnames.ora:
DB01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-lax)(PORT = 1521))
(CONNECT_DATA =
(SID = db01)
)
)
DB01-DEN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-den)(PORT = 1521))
(CONNECT_DATA =
(SID = db01)
)
)
Standby tnsnames.ora:
DB01-LAX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-lax)(PORT = 1521))
(CONNECT_DATA =
(SID = db01)
)
)
DB01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = db01-den)(PORT = 1521))
(CONNECT_DATA =
(SID = db01)
)
)
Michael Dinh
NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
individual or entity to which it is addressed, and may contain information that
is privileged, confidential and exempt from disclosure under applicable laws.
BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION
(PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS
FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN,
EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR
OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this
email (and attachments) is not the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. Please notify the sender of the error and delete the
e-mail you received. Thank you.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Storey, Robert (DCSO)
Sent: Wednesday, July 27, 2011 10:43 AM
To: oracle-l-freelists
Subject: Question for Dataguard users
Okay, have a question for the dataguard users. Probably more for the non-RAC
folks than anything.
My setup is a primary and a single physical standby.
In the event of a switchover, all user connections are broken and the switch
occurs. Then users have to reconnect.
But, I'm looking for the best way to structure the TNSNAMES file. I'm probably
over thinking this, but, there has to be a way to create both entries for both
servers in the file, but only have them use the production one. Something
tickles my brain from way back that it will run the TNS list in order looking
for a connection.
Just curious how others have set up their files.
Thanks
Other related posts:
