RE: Oracle 10g and Standby Database Setup

I would just like to throw in a personal observation on 64 bit Windows
2003, Oracle 10g release 2 Enterprise Edition.  DataGuard is clutter.
In order to utilize DataGuard you are required to install an additional
layer of software on your server.  File based replication using
something like dfs to ship your archive redo logs works much better in
my personal opinion and doesn't tie your hands with a gui.  I guess I am
hard core and prefer to do things by command line.  BTW - what happens
when you have gui problems with DataGuard?  This is yet another layer of
software waiting to cause you headaches.  I guess I am old school...

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield
Sent: Tuesday, March 18, 2008 3:35 AM
To: pythianbrinsmead@xxxxxxxxx; ronnie_doggart@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle 10g and Standby Database Setup

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

--
http://www.freelists.org/webpage/oracle-l


Other related posts: