Re: Oracle DataGuard to prevent corruption?

On Mar 1, 2:28 pm, DA Morgan <damor..._at_psoug.org> wrote:
> joel garry 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).
>
> > jg
> > --
> > @home.com is bogus.
> >http://www.extremetech.com/article2/0,1697,2099068,00.asp
>
> I agree that you would probably want to license the standby server but
> it is not required and doing so depends on your SLA and black-out
> window. That said ... there still is no additional cost for Data Guard.

Hmmmm... "For educational purposes only," note the differences between failover and standby: http://www.oracle.com/corporate/pricing/databaselicensing.pdf

And the date.

I make no comment on contract negotiations. I hope everyone gets a great deal!

jg

--
@home.com is bogus.
http://maps.yahoo.com/broadband/#mvt=h&lat=33.9254&lon=-118.4298&mag=6&env=a