Re: 11.1.0.6 + Linux + physical standby
- From: kathryn axelrod <kat.axe@xxxxxxxxx>
- To: mary_mcneely@xxxxxxxxx
- Date: Sat, 7 Apr 2012 00:09:18 -0700
Hi Mary Elizabeth,
Right now we have an 11.1.0.7 EE RedHat physical standby setup. It's
not RAC or ASM, so not 100% what you're looking for, but hopefully
still be helpful...
I haven't encountered any gotchas...The only ones I am aware of are
the same as any setup - the bugs that exist for each version and
product..(including DG specific patchsets).
For standby creation, I typically use a hot backup script or an image
copy; but a duplicate (duplicate target database for standby) would
work just as well.
Personally, I think the offerings of DG (e.g. fast-start failover) are
definitely worth any extra pre-prod testing you may be inclined to
perform based on your predecessor's setup.
-k
On Thu, Apr 5, 2012 at 7:51 PM, Mary Elizabeth McNeely
<mary_mcneely@xxxxxxxxx> wrote:
> All,
> I have a situation where there's an 11.1.0.6 EE database on Linux that's
> running a "homemade" physical standby database (manual shipping/application
> of archived redo logs to the standby database). It's three-node RAC with ASM.
> The previous DBA (who graciously still answers questions for us) says it was
> that way when he got there, and he doesn't know why.
> My guestimate is that the earlier DBAs decided not to use a DataGuard
> physical standby because their homemade solution lets them zip the logs prior
> to shipment, lessening the network load.
> It's time to rebuild the standby, and we're thinking of changing to a
> DataGuard standby - seems much easier to just let Oracle do its thing instead
> of reinventing the wheel.
> But it haunts us that we're missing something like a bug or some other gotcha.
> To that end, do any of you currently (or previously) run 11.1.0.6 EE on Linux
> with a physical standby database? Was it single node or RAC? With ASM or
> without? How did you build your standby - RMAN DUPLICATE or some other
> method? What gotchas did you encounter?
> I appreciate any feedback you can offer in this regard, and thanks in advance
> for your time.
> Kind regards,
> Mary Elizabeth
> (oracle-l lurker)
> --
> http://www.freelists.org/webpage/oracle-l
>
>
--
http://www.freelists.org/webpage/oracle-l
Other related posts: