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

From: Kamus <kamusis_at_gmail.com>
Date: Thu, 06 Jan 2005 20:02:17 +0800
Message-Id: <20050106194703.4794.KAMUSIS@gmail.com>

Sorry, I don't think so.
First, the storage is cheaper and cheaper this days, buy onemore cheap dell-emc Storage System maybe enough.
Second, by setting up 2 independent standby databases we could get a much more flexible anti-disaster environment. such as 1 be a physical and the other be a logical, or 1 be a instant apply and the other be a delayed apply, etc...
Though oracle said standby database support RAC, at least so far I won't use this function.

On Thu, 6 Jan 2005 12:11:07 +0100 (CET)
"Carel-Jan Engel" <cjpengel.dbalert_at_xs4all.nl> wrote:

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

>=20

> Kamus,

>=20

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

>=20

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

>=20

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

>=20

> Regards, Carel-Jan

>=20

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

>=20
>=20
>=20


> >

> > On Thu, 6 Jan 2005 10:06:27 +0530

> > Sriram Kumar <k.sriramkumar_at_gmail.com> 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 9.2.0.4

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

>=20

--=20
Kamus <kamusis_at_gmail.com>

=C4=C7=C3=B4=B6=E01G=B5=C4=D3=CA=CF=E4=A3=AC=CE=D2=C4=DC=D3=C3=C0=B4=B8=C9= =CA=B2=C3=B4:-)
A Oracle8i & 9i Certified DBA from China

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 06 2005 - 06:04:39 CST