Re: automatic standby database failover

From: Job Miller <jobmiller_at_yahoo.com>
Date: Fri, 21 Dec 2012 04:57:45 -0800 (PST)
Message-ID: <1356094665.43413.YahooMailNeo_at_web126102.mail.ne1.yahoo.com>

regardless of whether the dg failover is automatic, the clients should be pre-configured to support the db running at either primary or standby site when failover does happen. http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr2-client-failover-173305.pdf

---

 From: Marcin Przepiorowski <pioro1_at_gmail.com> To: oracledbaquestions_at_gmail.com
Cc: oracle-l_at_freelists.org
Sent: Friday, December 21, 2012 4:29 AM
Subject: Re: automatic standby database failover  

On Thu, Dec 20, 2012 at 9:43 PM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:
> Anyone ever automate the failover to a standby database? All code or a
> product, no human interaction? I got asked about the ability to failover to
> another database in 20 minutes. Which means new DB online and all the
> applicatons, and everything else pointing to it. This sounds like it might
> be better suited for golden gate (I have used this some, but don't know it
> real well).
>

Hi,

Data Guard with FastStart Fail Over configuration is what you are looking for.
You need to have additional server with DataGuard Observer running on it and depend on application find out a best way for you to redirect traffic from primary to standby site.

regards

-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 21 2012 - 13:57:45 CET