Home > Ask the Storage Technology Experts > Questions & Answers > Two-node cluster over Oracle 9i
Ask The Storage Expert: Questions & Answers
EMAIL THIS

Two-node cluster over Oracle 9i

Evan Marcus EXPERT RESPONSE FROM: Evan Marcus

Pose a Question
Other Storage Categories
Meet all Storage Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 20 July 2005
My S/W architecture has one database server (Oracle 9i), one application (SybaseEA) and Business Object and Web Intelligence. The vendor says the application doesn't support clustering. I am trying to deploy via port (switch) level mirroring. How do I perform the same task on database level?

a) SAN -- how do I have failover
b) DAS -- two servers attached to two DAS for failover


>
It sounds as though you want to build a two-node cluster on top of Oracle 9i. This is actually one of the most common uses for clusters and clustering software. The architecture for such a cluster requires a minimum of three networks on each node, and a mirrored set of disks connected by either SAN or DAS. You could use NAS, but doing so would add a level of complexity that I would advise against.

Each node must be on two dedicated private networks for cluster heartbeats. Each node must also have one port (or more) on the public network so that database clients can reach them. The nodes must also be attached to shared storage over two ports. Ideally, the storage will be mirrored between a pair of disk arrays, so that there is no single point of failure.

The final piece you'll need is some sort of cluster management software. You did not specify the OS that your applications run on, but in general, you'll be well-served by using Veritas Cluster Server (recently acquired by Symantec) or the clustering software sold by your platform vendor.


BROWSE BY TAG
Data Backup,   Data storage backup tools,   VIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Data storage backup tools
Hot storage technologies for 2010
Improved enterprise storage management tools are needed, especially for data backup
Enterprise data storage capacity management tools still found lacking
Storage configuration needs go beyond SRM tools
Remote site monitoring often missing from disaster recovery plan
Enterprise data storage performance monitoring goes beyond storage arrays
Backup in a snap: A guide to snapshot technologies
Growing need for email archiving
Addressing storage performance bottlenecks in enterprise data storage
Software vendors expand data deduplication offerings
Data storage backup tools Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
backup  (SearchStorage.com)
Backup and recovery: Do you speak geek?  (WhatIs.com)
backup robot  (SearchStorage.com)
backup storage  (SearchStorage.com)
cold backup  (SearchStorage.com)
continuous data protection  (SearchStorage.com)
replication  (SearchSQLServer.com)
storage snapshot  (SearchStorage.com)
virtual tape  (SearchStorage.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Search for Data Management Tools
TechTarget Storage Media
Storage Magazine View this month\\'s issue and subscribe today.
Storage Decisions Apply online for free conference admission.
SearchStorage.com
HomeNewsMagazineTopicsLearningMultimediaWhite PapersBlogsEventsAbout Us

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts