| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cluster query
Sean,
If you cluster NT you have at least 2 options - OPS (or RAC if on 9i) or failsafe.
OPS is an extra cost option (perhaps around $US20,000 per processor).
OPS will allow DB processing to occur on both nodes, and bring with it all the admin, configuration and other overhead.
Failsafe is free but will only allow each database to be open by a single instance.
Below is a somewhat old but probably still relevant description of Fail Safe from a Metalink forum discussion:
"
Windows NT Enterprise Edition or Windows 2000 and MSCS are installed on each cluster node. Oracle Fail Safe Server and all other executable Oracle software are installed on a private disk (usually the system disk) on each node.
Product-related files that must be accessible to either cluster node (for example, the data, control, and log files associated with a database instance) are installed on the cluster disks attached to the shared storage interconnect between the nodes. The database files only exist on the shared drives. In addition, Oracle Fail Safe Manager is usually installed on the management system for the Windows NT domain containing the cluster.
Hardware RAID is recommended for all disks on the shared storage interconnect, to eliminate disk drives as a potential single point of failure.
You can use ARCHIVELOG mode in a Fail Safe configuration. Basically you have to use the FSCMD utility to shutdown the database (you have to use this utility anytime you shutdown the database so it doesn't fail over) and then you would follow the standard procedure for implementing archiving. Backup and Recovery options are the same for a Fail Safe environment.
I have included a note on ARCHIVELOG mode in a Fail Safe environment.
How to Place Database In Archivelog Mode When in Fail Safe
Included with the Oracle Fail Safe release 3.0.4 is a Concepts and Administrator's manual which is very detailed and will provide more information for you.
Melissa Holman
Oracle Support
"
I would start by looking for the Fail Safe doco on Technet as well as the OPS doco.
What are you hoping to gain by implementing clustering - this would help determine which (if either) is suitable for you. You may find standby, replication, long distance hardware mirroring or some other method may better suit your requirements.
HTH,
Bruce Reardon
-----Original Message-----
Sent: Friday, 15 February 2002 23:23
So our Sys Admins bods are talking about clustering using Compaq kit for W2K based server with an 8.1.7 DB. I take it we're talking implementing OPS from the DBA POV?. Are there other possibilites?.
Anyone any experience with above mentioned H/W and S/W care to share hard won experience, gotcha's etc... and no quips about Unix instead of NT pleez cos that ain't gonna change =:-0
Can anyone recommend any useful sources of info via web sites, White papers etc.
Hope I'm not being too vague and asking too big a question!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon_at_comalco.riotinto.com.au 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).Received on Sun Feb 17 2002 - 18:03:19 CST
 |
 |