Re: Standy database on standard edition
Date: Thu, 13 Jun 2013 00:14:14 -0500
Message-ID: <20130613001414.6fe57e44_at_jeremy-nb>
I think there's one more thing you're forgetting. I love dbvisit - it's an excellent product. Please correct me if I have this wrong, but I think that besides the process/workflow automation, you get another thing when you buy DG: LGWR mode instead of ARCH mode. (In fact, starting with 11gR1 LGWR is now default and ARCH is deprecated.)
http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_arch_dest_param.htm#SBYDB01103
The main difference here is that with dbvisit or any other homebrew solution, you changes are only sent to the remote site when you do a log switch. With DG your changes are generally sent within a few seconds (as long as there aren't network problems) and if you switch to MAX PROTECT or MAX AVAIL modes then the data is sent off-site before the commit returns.
The upshot is that with DG, your "maximum data loss" is seconds and can even be zero. Without DG, your maximum data loss is at best a few minutes if you crank the log switching up to be very frequent. You will find this in the dbvisit docs if you dig around a little.
IMHO, only a very few businesses require max data loss of less than a minute when their datacenter floods during a hurricane - I think that keeping the max possible loss under 10 minutes should usually be fine. So I don't think this should be a show stopper. But worth pointing out. (Assuming I have this right <g>)
-Jeremy
-- http://about.me/jeremy_schneider On Wed, 12 Jun 2013 09:00:26 -0600 Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:Received on Thu Jun 13 2013 - 07:14:14 CEST
> And, as clarification, standby is not DataGuard. DataGuard is simply
> a technology that automates the process [work] flow of standby for
> Oracle databases: the extraction, shipping, receiving, application of
> logs and coordinated switchover/failover control.
>
> Basically Oracle is saying you can not configure DG, although nothing
> - as far as I can tell - is stopping you from manually doing the same
> thing as Data Guard provides.
>
> Rather than try to duplicate DG capabilities, just peek at DbVisit,
> an Oracle partner who provides a great & legal standby solution for
> Standard Edition at a very reasonable price. http://dbvisit.com
-- http://www.freelists.org/webpage/oracle-l