Re: Oracle DataGuard to prevent corruption?

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Wed, 28 Feb 2007 21:27:11 +0000
Message-ID: <newscache$flz6ej$ma7$1@newsfront4.netvisao.pt>

DA Morgan wrote:

> 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.

I recomend the reading of the MAA (Maximum availability architecture) document from Oracle.

http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm

regards,
pedro Received on Wed Feb 28 2007 - 15:27:11 CST