Re: Oracle DataGuard to prevent corruption?

On Feb 27, 8:13 pm, Magnus Warker <mag..._at_warker.co> wrote:
> Dear group,
>
> we encountered a serious problem with our Oracle database cluster. Data
> corruption occurred and a fixed set of records is not readable anymore. It
> seems that this was caused by heavy loads, but there still is no
> clarification of what really happened.
>
> Our consultant made the advice to setup a new installation with a product
> named DataGuard. This would operate with two copies of the same database,
> and, when data corruption occurs on one database, we still would have the
> other one.
>
> What do you think of this kind of workaround, especially from the point of
> view that we are already operating a high available database cluster, which
> would become needless in this case?
>
> Thank you
> Magnus

Here's a slideshow of what the others are saying (click on 40073): http://www.oracle.com/openworld/archive/paris2003/index.html

Also see http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html

I think it is misleading saying "Data Guard is available as an integrated feature of the Oracle Database (Enterprise Edition) at no extra cost," though. You have to license the standby server just like the primary. That sounds like up to twice the cost to me! (Theoretically more in the case of one company I know, who's primary is a 4-cpu, and standby is a 6-cpu older and slower machine).

jg

--
@home.com is bogus.
http://www.extremetech.com/article2/0,1697,2099068,00.asp