Re: 11.1.0.6 + Linux + physical standby

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