RE: Oracle 10g and Standby Database Setup

From: William Wagman <>
Date: Tue, 18 Mar 2008 09:06:47 -0700
Message-ID: <>


I am puzzled by your comment that on Windows " you are required to install an additional
layer of software on your server." I have just configured DataGuard "out of the box" on a 64-bit Windows 2003, Oracle 10gR2 EE and it is working. Perhaps the admin who did the windows installation did something I am unaware of. I'm not sure if I am misunderstanding your note or if there is something I am missing.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208
-----Original Message-----
[] On Behalf Of Johnson, William L (TEIS)
Sent: Tuesday, March 18, 2008 5:13 AM
To:;;; Subject: 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-----
[] On Behalf Of Niall Litchfield Sent: Tuesday, March 18, 2008 3:35 AM
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 <> 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)
> 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
> 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
> performance" mode. Sadly, they are not mine to share.
> On Mon, Mar 17, 2008 at 1:34 AM, Ronnie Doggart
> 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
> > 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
> > 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
> > and opinions of any member of Lagan Technologies Limited, or any of
> > subsidiaries.
> >
> > Lagan Technologies Limited is a company registered in Northern
> > with registration number NI 28773. The registered office of Lagan
> > Technologies Limited is 209 Airport Road West, Belfast, Co. Antrim,
> 9EZ.
> >
> > --
> >
> >
> >
> >
> --
> Cheers,
> -- Mark Brinsmead
> Senior DBA,
> The Pythian Group

Niall Litchfield
Oracle DBA


Received on Tue Mar 18 2008 - 11:06:47 CDT

Original text of this message