High availability and upgrades

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Thu, 10 Jul 2003 10:05:52 -0700
Message-ID: <F001.005C446B.20030710095925@fatcity.com>

We're considering high availability options. One of our requirements is to be able to take one database offline (i.e., direct all application connections to a second database server), perform database and application upgrades, and perform a few hours' worth of tests before bringing it back online. We would then take the second database offline and repeat the procedure.

We've tried Data Guard logical standby but it's incompatible with Label Security (which we plan to run), presents performance problems, and has a number of bugs. We'd like to use the secondary database for reporting as well, so a physical standby isn't practical.

RAC doesn't give us a second database copy.

Multimaster replication requires that changes to replicated objects be made via DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the changes to all masters at once.

We haven't tested Streams yet.

I'd be interested in hearing of any experiences from those who have the same or similar requirements.

Paul Baumgartel

---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Paul Baumgartel
  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). Received on Thu Jul 10 2003 - 12:05:52 CDT