RE: Oracle 10g and Standby Database Setup

From: Mark W. Farnham <>
Date: Mon, 17 Mar 2008 20:59:09 -0400
Message-ID: <00ce01c88893$47938780$>

  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 product.
  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: [] On Behalf Of Crisler, Jon
Sent: Monday, March 17, 2008 5:11 PM
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: [] On Behalf Of Ronnie Doggart
Sent: Monday, March 17, 2008 3:35 AM
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 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.



-- Received on Mon Mar 17 2008 - 19:59:09 CDT

Original text of this message