Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: 2 Node RAC Standby -- A mix of Managed Recovery and Read only?
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
>=20
>=20
>=20
>=20
>=20
>=20 >=20 >=20> >> like an potential enhancement request for future releases.
> >
> > 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
--=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-lReceived on Thu Jan 06 2005 - 06:04:39 CST
![]() |
![]() |