RE: Oracle 10g and Standby Database Setup

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <Jon.Crisler@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 17 Mar 2008 20:59:09 -0400

1) I tend to agree with Jon. They do a lot to prevent you from shooting
yourself in the foot and provide options to tailor the
DG/recoverability/performance tradeoff mode by just choosing options in the
2) If you insist on rolling your own, I'm not aware of any holes in "Getting
the most from your Standby/Reporting Server" by yours truly from 1995.

Good luck.
Consider hiring someone who knows what they are doing to do one for you that
you can copy.
After you price out that option, reconsider the license fees in context.

All that said, if you avoid the classic errors such as not creating new
standby database files before any redo with respect to them is applied and
remember about either force logging or accounting for unlogged operations,
the basic operations are simply recovery. It has worked reliably since at
least 6.0.36.xx. One of my favorite conversations ever with support went
something like this:

Them: We don't support remote recovery systems.
Me: So you're telling me that you do not support physical recovery. Would
you like to explain exactly what it is you do not support before I'm forced
to grant an interview to Computerworld?
Them: Give us a day.
Them: (Actually less than a day later) We fully support the physical
recovery model. However, if you fail to create new files prior to recovery
or use unlogged operations, then a "standby" system may not adhere to the
rules of recovery, so we do not support it completely.
Me: Okay, so as long as I follow the physical recovery model rules and don't
expect you to magically materialize repairs to things I broke, you've got no
problem with supporting the physical recovery model.
Them: Correct. And Bill says hi.



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Crisler, Jon
Sent: Monday, March 17, 2008 5:11 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle 10g and Standby Database Setup

I hate to sound blasé, but:

1) Upgrade to Enterprise Edition
2) Use DataGuard

Been there, done that, and EE and Dataguard is much easier to use.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Ronnie Doggart
Sent: Monday, March 17, 2008 3:35 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle 10g and Standby Database Setup


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

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

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.




Other related posts: