vxdg in veritas cluster which host oracle database

[headbig]

Hello,everybody Recently I have sfha enterprise for AIX installed. and i will use it to cluster my two nodes oracle database. These two nodes share one storage.So I created vxdg for cluster, but I don't know which disk group type I can use,private disk group or shared disk group? If I select shared disk group,then applications on other node can simultaneously access the same disk,maybe it can write on it.So I want to know how to control it ? In other words how the vcs control the storage which use for oracle database in two nodes cluster?

[g_lee · Accepted solution]

If you want simultaneous access to the diskgroup/volumes/filesystems, you need CVM/SFCFS - this requires additional license. Check vxlicrep -e output to see if the feature is enabled - if not, you'll need to speak to your account team to obtain the extra license, then install the additional product components.

Note: if you're planning on using Oracle concurrently you will need SFRAC which is a different product/has more features (and you'd also need to purchase Oracle RAC license from Oracle).

If you do plan to use SFCFS, would strongly recommend you take a look at the Installation and Administrator's Guides (SF 5.1 for AIX versions below)
Veritas Storage Foundation Cluster File System Installation Guide
http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/sfcfs_install.pdf

Veritas Storage Foundation Cluster File System Administrator's Guide
http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/sfcfs_admin.pdf

this may also be helpful:
Veritas Storage Foundation: Storage and Availability Management for Oracle Databases
http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/sf_adv_ora.pdf

Further documentation is available here: https://vos.symantec.com/documents

If you just want to know how VCS handles failover diskgroups (for private/non-shared diskgroups) - see the VCS User's Guide and VCS Bundled Agents Reference Guide for details

VCS Administrator's Guide
http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/vcs_admin.pdf

VCS Bundled Agents Reference Guide (see: Storage agents -> DiskGroup agent)
http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/vcs_bundled_agents.pdf

[Anoop_Kumar1]

The answers depends on questions , how you are using Oracle ?

1. Single instance of Oracle that runs only on one node at one time and other node in cluster is idle.

Here, Oracle runs on one node at one time and failovers to another node in case of fault on resources ( diskgroup, mount point, ip addresss, NIC ) or active node is down. Oracle is controlled by Oracle agent available from Symantec.

http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/vcs_oracle_agent.pdf

2. Multiple instances of Oracle running on multiple nodes in cluster.

SFRAC provides environment to control Oracle RAC. In Oracle RAC, mulitple instances of Oracle runs on mulitple nodes. And shared diskgroups are used to shared the same database among these multiple nodes. Shared diskgroup control is managed by CVM/CFS i.e cluster volume manager and cluster filesystems. Oracle clusterware which controls multiple isntances of Oracle is also managed by VCS.

http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/sfrac_install.pdf
http://sfdoccentral.symantec.com/sf/5.1/aix/pdf/sfcfs_notes.pdf

Regards
~Anoop

[headbig]

Many thanks!

I want to use active/standby  on my  oracle database. I only have sfha license,no cluster file system license.


If I use private disk type,the active node handle the disk ,if it failed, then it move to standby node,and it get the disk. Am i right?

[Gaurav_S]

Yes, you are right .... the disk should be coming from a shared storage & should be visible to both the nodes...

Gaurav