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)
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: