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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).