Veritas InfoScale™ 8.0 Oracle データベース用ストレージと可用性管理 - AIX, Linux, Solaris

Storage Foundation for Oracle RAC のサンプル設定ファイル

include "OracleASMTypes.cf"
include "types.cf"
include "CFSTypes.cf"
include "CRSResource.cf"
include "CVMTypes.cf"
include "MultiPrivNIC.cf"
include "OracleTypes.cf"
include "PrivNIC.cf"

cluster cluster1 (
        UserNames = { admin = hqrJqlQnrMrrPzrLqo,
                 "root@sxsvm02" = 0,
                 "root@sxsvm03" = 0 }
        Administrators = { admin, "root@sxsvm02",
                 "root@sxsvm03" }
        SecureClus = 1
        UseFence = SCSI3
        HacliUserLevel = COMMANDROOT
        )

system system1 (
        )

system system2 (
        )

group VxSS (
        SystemList = { system1 = 0, system2 = 1 }
        Parallel = 1
        AutoStartList = { system1, system2 }
        OnlineRetryLimit = 3
        OnlineRetryInterval = 120
        )

        Phantom phantom_vxss (
                )

        ProcessOnOnly vxatd (
                IgnoreArgs = 1
                PathName = "/opt/VRTSat/bin/vxatd"
                )



        // resource dependency tree
        //
        //      group VxSS
        //      {
        //      Phantom phantom_vxss
        //      ProcessOnOnly vxatd
        //      }


group cvm (
        SystemList = { system1 = 0, system2 = 1 }
        AutoFailOver = 0
        Parallel = 1
        AutoStartList = { system1, system2 }
        )

        Application cssd (
                Critical = 0
                StartProgram = "/opt/VRTSvcs/rac/bin/cssd-online"
                StopProgram = "/opt/VRTSvcs/rac/bin/cssd-offline"
                CleanProgram = "/opt/VRTSvcs/rac/bin/cssd-clean"
                MonitorProgram = "/opt/VRTSvcs/rac/bin/cssd-monitor"
                )

        CFSMount ocrmnt (
                Critical = 0
                MountPoint = "/ocr_vote"
                BlockDevice = "/dev/vx/dsk/ocrdg/ocrvol"
                )

        CFSfsckd vxfsckd (
                )

        CVMCluster cvm_clus (
                CVMClustName = sfrac_rp2
                CVMNodeId = { system1 = 0, system2 = 1 }
                CVMTransport = gab
                CVMTimeout = 200
                )

        CVMVolDg ocrvoldg (
                Critical = 0
                CVMDiskGroup = ocrdg
                CVMVolume = { ocrvol }
                CVMActivation = sw
                )

        CVMVxconfigd cvm_vxconfigd (
                Critical = 0
                CVMVxconfigdArgs = { syslog }
                )

        PrivNIC ora_priv (
                Critical = 0
                Device @system1 = { NIC1 = 0, NIC2 = 1 }
                Device @system2 = { NIC1 = 0, NIC2 = 1 }
                Address @system1 = "192.168.12.1"
                Address @system2 = "192.168.12.2"
                NetMask = "255.255.240.0"
                )

        cssd requires ocrmnt
        cssd requires ora_priv
        cvm_clus requires cvm_vxconfigd
        ocrmnt requires ocrvoldg
        ocrmnt requires vxfsckd
        ocrvoldg requires cvm_clus
        vxfsckd requires cvm_clus


        // resource dependency tree
        //
        //      group cvm
        //      {
        //      Application cssd
        //          {
        //          CFSMount ocrmnt
        //              {
        //              CVMVolDg ocrvoldg
        //                  {
        //                  CVMCluster cvm_clus
        //                      {
        //                      CVMVxconfigd cvm_vxconfigd
        //                      }
        //                  }
        //              CFSfsckd vxfsckd
        //                  {
        //                  CVMCluster cvm_clus
        //                      {
        //                      CVMVxconfigd cvm_vxconfigd
        //                      }
        //                  }
        //              }
        //          PrivNIC ora_priv
        //          }
        //      }


group ora_db (
        SystemList = { system1 = 0, system2 = 1 }
        AutoStart = 0
        AutoFailOver = 0
        Parallel = 1
        AutoStartList = { system1, system2 }
        )

        CFSMount archive_mnt (
                Critical = 0
                MountPoint = "/oraarchive"
                BlockDevice = "/dev/vx/dsk/oradg/archivevol"
                )

        CFSMount ora_data_mnt (
                Critical = 0
                MountPoint = "/oradata"
                BlockDevice = "/dev/vx/dsk/oradg/oradatavol"
                )

        CVMVolDg ora_data_voldg (
                Critical = 0
                CVMDiskGroup = oradg
                CVMVolume = { oradatavol }
                CVMActivation = sw
                )

        Oracle ORACLE (
                Sid @system1 = orarp1
                Sid @system2 = orarp2
                Owner = oracle
                Home = "/oracle/app/orahome"
                Pfile @system1 = "/oradata/orarp/spfileorarp.ora"
                Pfile @system2 = "/oradata/orarp/spfileorarp.ora"
                StartUpOpt = SRVCTLSTART
                ShutDownOpt = SRVCTLSTOP
                )

        requires group cvm online local firm
        ORACLE requires archive_mnt
        ORACLE requires ora_data_mnt
        archive_mnt requires ora_data_voldg
        ora_data_mnt requires ora_data_voldg


        // resource dependency tree
        //
        //      group ora_db
        //      {
        //      Oracle ORACLE
        //          {
        //          CFSMount archive_mnt
        //              {
        //              CVMVolDg ora_data_voldg
        //              }
        //          CFSMount ora_data_mnt
        //              {
        //              CVMVolDg ora_data_voldg
        //              }
        //          }
        //      }