Re: Oracle DataGuard to prevent corruption?

On Feb 28, 4:57 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> 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 seehttp://www.oracle.com/technology/deploy/availability/htdocs/DataGuard...
>
> 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).
>

It's unclear and opinions vary widely regarding the licensing requirements for a cold standby server.

Discussions and negotiations are called for here not an immediate decision to ante up.

Let's not forget the old 4th business quarter rule also. Received on Wed Feb 28 2007 - 16:32:13 CST