Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> re : cccp,sap, clustering

re : cccp,sap, clustering

From: Piet de Visser <piet.de.visser_at_logicacmg.com>
Date: Thu, 25 Sep 2003 03:14:32 -0800
Message-ID: <F001.005D10AC.20030925031432@fatcity.com>

Jared, Group,

briefly : my preferred cluster has 4 or more machines, with a single oracle-home installed on the SAN. Optionally: a physical standby system of 2 or more machines with stdby db running, lgwr for transport, in max-avail-mode.

a second oracle_home will be kept on the same san, but will be silent/unused during normal operations.

Only on upgrades or tests will the 2nd ora-home be mounted to 1 of the nodes, so the upgrade can be performed. when upgrade is deemed a success, all other nodes will 1-by-1 stop, unmount-ohome, re-mount the patched ohome, and business continues as usual.
When the last node is up for patch,
we can either san-snap the new ohome,
upgrade manually, or keep it for a while, to please damanagement with a rollback option.

Alternatively, the standby-db can be used for a "running-upgrade", but this process is much more complex.

Guiding principles:

Doubts: how many nodes or databases can realistically be served by 1 ohome on 1 single filesystem. Have one cust who plans to run 5+ databases on a 2-node cluster. Go explain the options for growth...

When I tried to re-start an OFA discussion, some weeks back (Thank Tim, for nice reply), this was one of the items I wanted to try and shove INTO the STANDARD,
or at least, discuss with some bright and experienced minds.

Regards,

PdV
Oracle DBA, and Certified.
You figure out the rest.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Piet de Visser
  INET: piet.de.visser_at_logicacmg.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).
Received on Thu Sep 25 2003 - 06:14:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US