From dgoulet@vicr.com Fri, 17 Aug 2001 10:13:47 -0700 From: dgoulet@vicr.com Date: Fri, 17 Aug 2001 10:13:47 -0700 Subject: Re:Oracle and MC/Serviceguard Message-ID: MIME-Version: 1.0 Content-Type: text/plain Riley, Having done this a couple of years ago: Put EVERYTHING on the shared disks. The major reason for this is that any temporary files created by our good friend Oracle to detect what has happen will be in $ORACLE_HOME/dbs by default. Failure to do so may cause your db to act very funny if not start up at all when the system switches over. In general you want the file systems to look identical in all respects when each machine is running as the 'prime host'. Now, as to your suggestion about upgrading, don't. The reason is that you have to take the db down one way or the other to upgrade and it's a lot better to do it once than to forget you did not upgrade the backup host. Dick Goulet ____________________Reply Separator____________________ Author: "Riley McLeod" Date: 8/17/2001 8:49 AM We are implementing MC/Serviceguard here for failover, and I have some questions about configuration/placement of Oracle files. Our Oracle environment: Oracle 8.1.6 (64-bit) HP-UX 11.0 (64-bit) We are not running OPS. The shared disks are on HP AutoRaid. Do all Oracle files need to be on the shared disks? I know that the datafiles for all data/index/rbs tablespaces need to be there, as well as the control files and online redo logs. How about datafiles for temp tablespaces or archive logs? One other thing: would it be possible to have the Oracle binaries *not* be on shared disks, so that for Oracle upgrades/patches we could failover, upgrade/patch Oracle on the primary host, then fail back to the primary and upgrade/patch Oracle on the backup host? Thanks in advance! Riley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Riley McLeod INET: rmcleod@morris.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.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).