RE: providing 24*7 database ---

Tim Gorman's paper
"Choosing Among High-Availability Architectures in Oracle" at

        www.evdbt.com/library.htm
might be useful. He lists options available and relative costs. Good luck!
Barb

> ----------
> From: Narender Akula[SMTP:narender.akula_at_TERRALINK.CO.NZ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, October 18, 2001 3:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: providing 24*7 database ---
>
> 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: Narender Akula
> INET: narender.akula_at_terralink.co.nz
>
> 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_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.com
-- 
Author: Baker, Barbara
  INET: bakerb_at_rockymountainnews.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_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).