From wisernet100@yahoo.com Fri, 19 Oct 2001 08:16:43 -0700 From: Rachel Carmichael Date: Fri, 19 Oct 2001 08:16:43 -0700 Subject: RE: providing 24*7 database --- Message-ID: MIME-Version: 1.0 Content-Type: text/plain Having been through (and still going through this)... we use one for queries, one for loading, when the loads are done, we do a backup then we switch the app to the "loading" database (coded so that as long as someone is connected the app doesn't switch over). once the app has switched, we down the "queries" database and rebuild it from the backup. then switch everyone back to that one. guy -- transportable has problems, and if the tablespace names are the same as existing ones, you can't do the transport. Rachel --- Guy Hammond wrote: > The thing that immediately springs to mind would be to use two > databases, one for queries, one for loading. Then, when the data was > ready, use a transportable tablespace to plug it in. There might be > some > post processing or redefining of views necessary. This is better than > using two schemas to do it, because you can have two instances on two > different machines, each instance tuned for exactly what you want to > do > with it, and the loading and the queries won't need to share I/O and > CPU. Altho' I guess you could use resource consumer groups and spread > the I/O across controllers. That way you could have one big machine > and > all its CPU would be available while loads weren't running. Hmmm. > > g > > > > > -----Original Message----- > Sent: Thursday, October 18, 2001 10:30 PM > To: Multiple recipients of list ORACLE-L > > > hi gurus, > > Our shop ( GIS oracle spatials ) attempting to provide a production > database > (7x 24 hours) , currently we have to offline database for users while > loading of data. > we donot what users to access data while loading. > We are thinking of provide 24* 7 services to customers with out going > offline. > What are the best possible solutions ? I had few but I donot know > its > right > direction ................. > > Possible Solutions > > Replication - > * not possible until Oracle 9i spatial (because of the > restriction on > replicating objects). > * Even then expense of additional licensing/machinery may be too > great > > Duplicate instances - have 2 instances and users switch from one to > other > after production load.-- how to implement ? > > Duplicate schema within current database. Have 3 schemas inside a > single > TIPSPROD instance. The schema with the current data remains in > production > until the second schema is loaded with the new data. This is can > only > work > if we introduce a third schema that holds the views. At certain > time, > we > redefine all the views in the DATAVIEWS schema. --- its kind of > duplication > --- certainly not my option > > Can some body direct me where to look or any ideas ? > TIA > > narender.akula > > > - > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Guy Hammond > INET: guy.hammond@avt.co.uk > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).