RE: Oracle 10g and Standby Database Setup

William,

        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 / www.capgemini.com
Fax: 508.229.2019 /  Email: richard.goulet@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience 
______________________________________________________________

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johnson, William L
(TEIS)
Sent: Tuesday, March 18, 2008 8:13 AM
To: niall.litchfield@xxxxxxxxx; pythianbrinsmead@xxxxxxxxx;
ronnie_doggart@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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-----
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



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.

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


Other related posts: