RE: data guard questions
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "eglewis71@xxxxxxxxx" <eglewis71@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Feb 2011 00:40:29 +0100
Yes this is possible. I have this kind of setup running on 10gR2 on windows.
The primary is replicating to the physical standby using the lgwr and the
physical standby is replicating to the logical standby using the archiver (I
think it was not possible to use the lgwr for this replication as well, but I'm
not sure anymore).
Following metalink note can also help you: Cascaded Standby Databases [ID
409013.1]
I'm not using the broker.
My main objection to the broker is that it keeps a separate repository for the
db parameters involved in a dataguard setup. As I'm a consultant I'm not always
on the client site (sometimes for several weeks or months) and the chance that
someone has altered a parameter in the spfile instead of using the broker,
resulting in a discrepancy between the two and possible unsuccessfull role
switches or failovers is pretty high.
I can understand that they needed it when there was no spfile yet, but today ...
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of ed lewis
Sent: vrijdag 11 februari 2011 18:30
To: oracle-l@xxxxxxxxxxxxx
Subject: data guard questions
Hi,
I'm getting ready to do a new install of
Dataguard. (Oracle 11.2.0, Solaris 10 64bit).
The plan is to create a physical, and a logical standby.
From what I understand, it's possible to have the primary
database replicate to the physical standby, and then have
the physical standby replicate to the logical standby ?
Is anyone doing this ? Any pros and cons you can share ?
I'm also looking at DG broker. We don't have plans to
use fast failover. Would you recommend using the broker ?
Pros, cons ?
Your feedback is appreciated.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
