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 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
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.
--
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
Received on Thu Mar 01 2007 - 16:28:13 CST
