Oracle on 2 RP7420

[James M. Dunn]

All,

I will be purchasing two RP7420 8 way servers, these two server will be S/G'd.

Can I run 2 Production Oracle database on Server1 , configured into a SG cluster between Server1 & Server2 while running 2 reporting Oracle database (non production on Server2)?

My goal is to shut down the reporting databases and allow the Production Databases use Server2 in the event of a Production server failure.

have any of you done this before?

JD

[TwoProc · Accepted solution]

I've done it.

It's simply an issue of adding Oracle shutdown scripts to the package before shuttling the disks over and bringing up the production Oracle system.

Hint One.

Life's easier if you make sure that your volume groups have different names and different numbers for the "group" file in the volume group across BOTH computers. In other words, just make sure that across BOTH computers all volume group names are totally distinct (e.g. don't have a vg200 on both servers) name. Also make sure all volume groups have a distinct "group" file number across both machines.

That way when a vg travels from one machine to the other with the package it won't interfere with your reporting disks on the secondary server.

Hint Two.
HP's Service Guard scripts will want to leave the ORACLE_HOME directory out of the mix of stuff that's moved (their prototype would like to just move data drives). I preferred to go "off spec" from HP, and move the ORACLE_HOME and applications too, that way the exact patched version of the ORACLE_HOME and the patched applications moved with the package to the target server, and I wouldn't have to worry about keeping them in sync manually (or generating an automated method). This approach requires some extra additional scripting in the package too.

[James M. Dunn]

Great thats what I thought..

Thanks for the help

[James M. Dunn]

JD