Re: A basic replication question

Walt,

I presented a paper at IOUG Live 2003 and wrote an article on DBAZine on an issue similar to this. Although the issue addressed was something much more complex; the article does have scripts to set up a basic readonly snapshot (or MV) replication. The article is at http://www.dbazine.com/nanda2.html. Hope you will find it useful.

Best reagrds,

Arup Nanda

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 03, 2003 12:29 PM

> 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?
>
> Thanks,
> --Walt Weaver
> Bozeman, Montana
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Weaver, Walt
> INET: wweaver_at_rightnow.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).