Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 2 Node RAC Standby -- A mix of Managed Recovery and Read only?

Re: 2 Node RAC Standby -- A mix of Managed Recovery and Read only?

From: Carel-Jan Engel <>
Date: Thu, 6 Jan 2005 12:11:07 +0100 (CET)
Message-ID: <24334.>

> Why you want to configure your standby databases in RAC?
> 2 independent standby databases may be better.


I think there is not just a 'better' or 'right' solution. It all depends on a carefull tradeoff between possible solutions and budget after a one performed a careful investigation of possible risks to cover.

When business requires continuation on the standby site without performance loss, and RAC is the solution to provide that performance, having RAC on the standby site might be the way to go.

When the database is multi-TB, 2 independent standby databases might not be feasible due to the budget available for storage. Judgement on the quality of the solution, based on the data available, simply isn't possible.

Regards, Carel-Jan

If you think education is expensive, try ignorance. (Derek Bok) ===

> On Thu, 6 Jan 2005 10:06:27 +0530
> Sriram Kumar <> wrote:
>> Hi Gurus,
>> Firstly, I wish each and everyone of you a very happy, prosperous and
>> a healthy New Year.
>> I have a doubt regarding 2 Node RAC standby database.
>> 1. We have a 2 Node RAC database running
>> 2. We are planning to configure a 2 Node RAC standby database
>> 3. I understand from the Oracle docs that only one of the Nodes in a
>> RAC can be in a managed recovery mode.
>> My question is:
>> In the above context of one node performing a managed recovery and the
>> other node being idle, can we open the second node in a read only mode
>> ?. The manual says that I can't open the other node in read only mode
>> but why? would like to understand any limitations of the method
>> I had raised a TAR and the response from Oracle is
>> <Quote>
>> It sounds technically possible, but it is not in the product
>> today.Recovery is done when the database is in mount state and
>> readonly mode needs the database to be in open state. This state is
>> linked to the database and not the instance. So, basically, it sounds
>> like an potential enhancement request for future releases.
>> <Unquote>

Received on Thu Jan 06 2005 - 05:03:27 CST

Original text of this message