Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> A basic replication question

A basic replication question

From: Weaver, Walt <>
Date: Wed, 03 Sep 2003 08:29:27 -0800
Message-ID: <>

Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view.

I've looked into some options to do this. Since we're going to 9i fairly soon I was thinking of setting up logical standbys, but I've read some pretty bad things about logical standbys -- typical new buggy Oracle product.

I've also started into looking at basic replication: maybe just simple updateable snapshots refreshed every now and then.

So, for the past couple of days I've gone through Metalink, Technet, and the mail archives on Oracle-l trying to learn about simple, basic, readonly replication.

The problem is, all of the manuals, white papers, etc. I've found don't deal with how to set up and administer simple basic replication. It's all mixed in with multi-master replication, Advanced Replication, and stuff like that.

I'm new to replication and would like to basically start learning the basics for basic replication, basically.

Can anyone point me to a document that talks about basic read-only replication only? Or am I fooling myself into thinking there is such a thing?

--Walt Weaver

  Bozeman, Montana

Please see the official ORACLE-L FAQ:

Author: Weaver, Walt

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 03 2003 - 11:29:27 CDT

Original text of this message