Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

[Christhian Chamba]

Hi,

Is possible to make a cluster Active - Passive for ORACLE 10g R2 only with ServiceGuard or I need something more???...

Greetings,

[Emil Velez]

Oracle can work as a failover package in a serviceguard configuration.

HP Has a enterprise cluster master toolkit that has a sample script for oracle packaging and monitoring.

[SoorajCleris]

Hi,

It depends on which kinda cluster you want.
For an activ active cluster, you should implement Oracle RAC with help of SGeRAC over SG.

with only service guard , you may configure fail over package (active passive).
This will be normal process like shuting down the package on one node then starting it on other one.

Regards,
Sooraj

[Christhian Chamba]

Hi Emil / Sooraj,

I don't need an active - active cluster, I need a failover cluster; in this case only need a SeviceGuard, is correct???...

I install a HP-UX 11i v3, what is the best version of ServiceGuard that I need install for ORACLE 10g R2.

Greetings,
Christhian.

[Viktor Balogh · Accepted solution]

Hi,

>I install a HP-UX 11i v3, what is the best version of ServiceGuard that I need install for ORACLE 10g R2.

The latest SG version is 11.20, this is the recommended version to install to date.

Regards,
Viktor

[Christhian Chamba]

Hi Viktor,

Thanks your four answer, do you have any manual for configuring SG for ORACLE???...

Greetings,
CCH

[Alzhy]

Is your OE Mission Critical? You will ned a Mission Critical License to have ServiceGuard.


OR, you can just employ Poor Man's cluster by writing the scripts needed to quickly failover your Oracle Environment to another server.

[Viktor Balogh]

>do you have any manual for configuring SG for ORACLE???

obtain the "Serviceguard Enterprise Cluster Master Toolkit", it is a set of scripts helping to create HA-packages. There are some dedicated stuffs for Oracle:

http://h71028.www7.hp.com/enterprise/w1/en/os/hpux11i-serviceguard-toolkits-ecmt.html

here is a doc for setting it up, I hope the BSC link works:

http://h20000.www2.hp.com/bizsupport/TechSupport/CoreRedirect.jsp?redirectReason=DocIndexPDF&prodSeriesId=4162103&targetPage=http%3A%2F%2Fbizsupport2.austin.hp.com%2Fbc%2Fdocs%2Fsupport%2FSupportManual%2Fc02496200%2Fc02496200.pdf

>You will ned a Mission Critical License to have ServiceGuard.

AFAIK Serviceguard can also be licensed separately if you don't have the MCOE, but correct me if I'm wrong.

[Viktor Balogh]

oww. the link to the doc was screwed, here's a new one:

http://h20000.www2.hp.com/bizsupport/TechSupport/DocumentIndex.jsp?lang=en&cc=us&taskId=101&prodClassId=10008&contentType=SupportManual&docIndexId=64255&prodTypeId=18964&prodSeriesId=4162103

...and look for the

"Using the Oracle Toolkit in a HP Serviceguard Cluster README Revision: B.06.00, August 2010"

[Christhian Chamba]

Hi Alzhy,

Yes is a HP-UX 11i v3 High Availability OE,the idea is use a ServiceGuard for make a failover (Cluster Active - Passive) of Oracle 10g R2.

Hi Viktor,

Thanks for the information, I review the PDF "Using the Oracle Toolkit in a HP Serviceguard Cluster" and for now I have a one question, Whats is the better use a LVM or ASM for the Oracle Database???.

Greetings,
Christhian

[Alzhy]

If the toolkit now includes ASM in the configuration -- I'd prefer that - that is IF your DBAs are comfortable with it.

Otherwise, Cooked Oracle Storage LVM with 11.31's new DirectIO should be just as kool.


Why I suggested Poor Man' Cluster? Because it simply works, costs NIL and pretty much does what SG can do -- That is if you have good scriptwriters on board.

[Christhian Chamba]

Hi Alzhy,

Thanks for your help, in this case I use a ASM because is the recomendation for DBA.

I need use ServiceGuard because this is a migration of the infraestructure, actually the client have a Sysbase with a ServiceGuard in a Cluster Active - Passive.

Greetings,
CCH

[Viktor Balogh]

>Whats is the better use a LVM or ASM for the Oracle Database???

I would stick to the good'ol LVM, because ASM is not very known to me. Note that in an ASM filesystem you can't store anything. These two arguments are enough for me to go the LVM way.

In a system with ASM, the followings are

supported:

* Database files
* Control files
* Online redo log files
* Archived redo log files
* Flash recovery area files
* RMAN files (image copy and backup)

NOT supported:

* Installation files (in ORACLE_HOME, CRS_HOME)
* ORACLE_BASE files( including alert log, trace files, etc)
* CRS voting disk and OCR files
* Output data from UTL_FILE
* Any user or application specific files(e.g. XML or Java files)
* Oracle 9i external table files

[Christhian Chamba]

Hi Viktor,

Thanks for the recommendations, I talk with the DBA and review the 2 option: use a LVM or DBA but I don't have any problem with Serviceguard with the two options, it's correct???...

Greetings,
Christhian.

[Viktor Balogh]

>but I don't have any problem with Serviceguard with the two options, it's correct???...

No, both way is doable, the documentation is the proof of it. I just prefer LVM because I wouldn't assign volume manager tasks to a DBA. Ask your DBAs if they are familiar with ASM.

[Christhian Chamba]

Hi Viktor,

Thanks for your replies, I talk with the DBA about the ASM, and if he know about that, the best way is use ASM with the Serviceguard or not???...

Greetings,
Christhian Chamba

[Alzhy]

It depends HOW ASM is set up. If ASM is setup to use RAW LVM volumes (which is IDIOTIC imho), then the same facilities to failover LVM can be employed. Otherwise - IF the DB is on cXtYdz or diskNN or better yet (smartly named user defined names) -- then there IS nothing to be done by ServiceGuard as Storage Management is TOTALLY DONE by the package (the ASM Engine) --to seek out all the members. The important thing is to simply ensure the disk members are presented to the nodes -- and recognisable vy ASM_DISKSRTING.

[Christhian Chamba]

Hi Alzhy,

Thanks for your reply, I think that I need talk with the DBA because if he know about ASM only need configure the Serviceguard and the Storage Management is reponsability of the DBA.

What do you thing???...

Greetings,
Christhian Chamba