Re: automatic standby database failover
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Fri, 21 Dec 2012 09:29:33 +0000
Message-ID: <CAGdek=xo9iytHV6DTwN5+Mj0b+jprKCAFM+bvQHwjBvEeRiZcg_at_mail.gmail.com>
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).
>
Date: Fri, 21 Dec 2012 09:29:33 +0000
Message-ID: <CAGdek=xo9iytHV6DTwN5+Mj0b+jprKCAFM+bvQHwjBvEeRiZcg_at_mail.gmail.com>
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-lReceived on Fri Dec 21 2012 - 10:29:33 CET