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: - copies of ohome are not a good thing, not even if handled by OUI, OEM, or any other tool, - but I need 2 copies, just in case one of them breaks (analogy: ctl-files, redo-logs). - in all cases, I prefer to work from a single-point-of-maintenance. 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: [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).
