Re: Oracle 10g and Standby Database Setup
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: pythianbrinsmead@xxxxxxxxx, ronnie_doggart@xxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Mar 2008 07:34:54 +0000
That's correct. In fact the Oracle 7 docs were the chief resource that
went into building the standby that became the presentation and
scripts Jeremy referenced earlier. Things that are worth considering.
Are you expecting to do switchover or failover? You need to license
the standby. Do your dbas understand standby databases or do they just
know dataguard? What should be your method for detecting and resolving
gaps? How are you going to make the app resilient? Some of these
obviously apply to dataguard as well. I guess in summary I'm saying
that manual standby works just fine technically but there are a bunch
of management and other 'costs' some of which dataguard handles
directly for you. Incidentally I can say that should you ever give a
'you probably don't need ' presentation, having Tom Kyte, the product
manager (Larry Carpenter) and an industry expert (Carel-Jan Engel)
sitting right at the front concentrates the mind wonderfully.
On 18/03/2008, Mark Brinsmead <pythianbrinsmead@xxxxxxxxx> wrote:
> If you can dig it up, you may want to refer to the old Oracle7
> documentation. I am told (although I have never verified personally) that
> the old procedures for building a and maintaining an Oracle7 "standby"
> database work just fine with Standard Edition.
>
> In its most basic form, at least, all DataGuard does for you is provide a
> mechanism to transfer archived redologs and automatically applying them to
> the standby. Providing you are on a UNIX-like platform, neither operation
> is particularly hard to script. You need little more than SSH, SCP,
> SQL*plus, and a little imagination.
>
> I have seen one or two such scripted solutions for 9i and 10g Standard
> Edition, and they do a very good job of emulating DataGuard in "maximum
> performance" mode. Sadly, they are not mine to share.
>
>
> On Mon, Mar 17, 2008 at 1:34 AM, Ronnie Doggart <ronnie_doggart@xxxxxxxxx>
> wrote:
>
> > All,
> >
> > Does anyone have any white papers or step by step examples of setting up
> > an Oracle 10G environment with a standby database that does not use Data
> > Guard.
> >
> > This is for an Oracle 10G Standard Edition environment.
> >
> > All pointers welcome
> >
> > Ronnie Doggart
> >
> > The information in this message is confidential and may be legally
> > privileged. It is intended solely for the addressee. Access to this
> message
> > by anyone else is unauthorised. If you are not the intended recipient, any
> > disclosure, copying, or distribution of the message, or any action or
> > omission taken by you in reliance on it, is prohibited and may be
> unlawful.
> > Please immediately contact the sender if you have received this message in
> > error.
> >
> > The views and opinions expressed in this email may not reflect the views
> > and opinions of any member of Lagan Technologies Limited, or any of its
> > subsidiaries.
> >
> > Lagan Technologies Limited is a company registered in Northern Ireland
> > with registration number NI 28773. The registered office of Lagan
> > Technologies Limited is 209 Airport Road West, Belfast, Co. Antrim, BT3
> 9EZ.
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Cheers,
> -- Mark Brinsmead
> Senior DBA,
> The Pythian Group
> http://www.pythian.com/blogs
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
