RE: Oracle 10g and Standby Database Setup

From: Goulet, Dick <>
Date: Tue, 18 Mar 2008 08:55:44 -0400
Message-ID: <>


        If you want to be a command line guy, enjoy yourself. I am too & I've set up data guard from the SQL prompt without the use of dgmgrl and/or the gui. Works fine on Linux, Solaris, and Windows. And no you don't need any other piece of software. The lgwr or arch process will communicate to the standby via sql*net easily.

        And, in the desire to conserver bandwidth, someone asked if there's an easy way to see in if the recovery process is running and up to date. Try the following query on your standby:

SELECT max(decode(PROCESS, 'MRP0',
sequence#))-max(decode(process,'RFS',decode(CLIENT_PROCESS,'LGWR', SEQUENCE#),NULL))
FROM V$MANAGED_STANDBY; If the returned result is 0, then your working normally.

        You can also try:

Select process, sequence#, status from v$managed_standby where sequence# is not null order by 2;

Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / Fax: 508.229.2019 / Email: 45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience

-----Original Message-----
[] On Behalf Of Johnson, William L (TEIS)
Sent: Tuesday, March 18, 2008 8: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


This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient,  you are not authorized to read, print, retain, copy, disseminate,  distribute, or use this message or any part thereof. If you receive this  message in error, please notify the sender immediately and delete all  copies of this message.

Received on Tue Mar 18 2008 - 07:55:44 CDT

Original text of this message