ServiceGuard-OPS with Oracle9iRAC

[Frank Gomes]

My Oracle DBA told me he has an ORAC requirement that each instance archive logs for each system needs to be seen by all systems.

I believe this would reguire a cluster file system (CSF). I don't have CSF with ServiceGuard-OPS.

Does anybody have experience on how to manage archive logs in an Oracle9i RAC env.

Thanks in advance

[Stephen Doud]

Hi Frank,

I don't have an immediate answer for you, however the Oracle site discussing implementation is here:

Oracle9i Real Application Clusters (RAC) on HP-UX :
http://otn.oracle.com/products/oracle9i/htdocs/9iRAChp.html

Other 9i-related documents are linked here:
http://otn.oracle.com/documentation/oracle9i.html

Since SG-OPS does not support a direct-mount shared file system, NFS is the only alternative to making a file system available to all servers in the cluster.

-s.

[CCIL]

Hi !
The MC Service guard allows you to share a single volume group by two system i.e you can create a volume group & it will be accessible by the all the nodes which are in cluster. You can create oarclke realted file system on that volume group (preferable raw file systems) every node will have the oracle instane running & this oracle instance will access that particular volume gropu , so even if on node goes down the othe node can take over & that to without any loss of data.
You need to have a individual pacakge ruuning on each node , which will have the entry of this volume group & oracle instance.

[Gene Kornacki_3]

In my cluster each machine has it's own archive directory. I didn't have to do anything special during setup of the cluster or setup of the database in reguard to archive logs. Just specify where you want them to go and the software takes care of the rest.

[Alexander Santamaria Ji]

Hi Frank;

We have a cluster installation with MC/ServiceGuard OPS Edition an Oracle 9i RAC and solve this problem by configuring shared logical volumes, you must do that for each volume group.

You can use the following command:

vgchange -S y -c y vgxxx

The volume group assigned to the archive logs
must be shared and have to execute the above command on each server.

Best Regards,

Alexander Santamaria

[Michael Steele_2]

Regarding: "..My Oracle DBA told me he has an ORAC requirement that each instance archive logs for each system needs to be seen by all systems...."

This is also my experience with SG-OPS and Oracle 9i which is also taught in the Advanced HP SG class. And as Mr. Santamaria has pointed out:

vgchange -S y -c y vgxxx

...is the proper command to use in an LVM SG environment that enables similtaneous activation and writes from every node.

There is a lot more to setting up a oracle parallel server SG environment. Special EMS, Cluster Object Manger, SG-OPS, asyncdsk kernel driver, other adjustments to standard kernel parameters, and most of all different failover testing and failover types.

Refer to HP document H4310S B.00 or take the 3 day Advanced SG class. Its the last lab.