Re: Oracle DataGuard to prevent corruption?

Magnus Warker 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

RAC and DataGuard are both components of Oracle's high availability stack that do entirely different things. Without knowing the actual cause of what happened it is possible that neither would solve the problem.

Note: Data Guard is not a product ... is is built into the Enterprise Edition.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org