Re: Failover to DG physical standby
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: lyallbarbour@xxxxxxxxxxxxxxx
- Date: Mon, 8 Sep 2014 15:29:51 -0500
Normally you just set up a failover tns entry, with both the primary and
the standby nodes listed. Other methods include moving the name and/or ip
address to the standby server in case of primary failure. 11gR2 allows you
to define service named based on whether or not the database is primary or
standby, so you use the same service name. Somthing like this:
DEMODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PRIMARY)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = STANDBY)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = demodb)
)
)
On Mon, Sep 8, 2014 at 3:21 PM, Lyall personal <lyallbarbour@xxxxxxxxxxxxxxx
> wrote:
> All, more of a theoretical question then specifics and syntax needed.
> Therefore no version/OS info given
>
> We are working on a DR scenario at our company with two data centers.
> Trying to figure out how apps will connect to the DBs still when a disaster
> happens. How do you do it?
> I'm trying these tns features for FAILOVER and LOAD_BALANCE
>
> Thanks, Lyall
>
> Sent from my BlackBerry 10 smartphone.
> -- //www.freelists.org/webpage/oracle-l
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
