MC/Serviceguard

[Shivkumar]

Dear Sirs,

What is the role of MC/Serviceguard in Oracle 9i functioning ? How does Oracle 9i keeps data in synch with 2 instances of Oracle running on different physical hpux 11i servers ?

Thanks,
Shiv

[Patrick Wallek · Accepted solution]

It really depends on how you want to design you cluster. MC/SG itself has nothing to do with data replication.

Normally you would have disk that was shared between the 2 machines such that if one machine in the cluster went down, the other would start Oracle and mount the shared disk, thus you have the data available from the same point you left off.

I believe Oracle has some functionality, something like a standby database I think, where each DB write is duplicated to another database so that you have 2 instances kept in sync. If one fails you can bring the other online.

The are also options like EMCs SRDF and whatever HP's equivalent is.

[Sudeesh]

Two options are there:

1. Normal MC/ServiceGuard cluster where storage is shared between two machines and instance will run on one node, other node will act as fail-over.

2. MC/LockManager enables the Oracle Parallel Server RDBMS to run on HP 9000 high availability clusters under the HP-UX operating system. Below link points to the docs which will explains how OPS cluster works

http://docs.hp.com/en/B5158-90019/index.html

Hope this helps

Sudeesh

[Devender Khatana]

Hi,

You are talking about oracle RAC integration with MC Service Guard cluster. Here both nodes have oracle instance running and every operation is done on both nodes simultaneously.
In the event any of of the node failure users are served by the other node. This avaoids the restart of database on adoptive node which is required if you have oracle running without RAC in MC service guard cluster.

HTH,
Devender