Oracle 10g configuration for CVM/VVR secondary site
Configuration details:
-
Named: cvmvvr_secondary_main.cf
-
More general purpose, can have multiple Oracle databases
include "types.cf"
include "CFSTypes.cf"
include "CVMTypes.cf"
include "OracleTypes.cf"
include "PrivNIC.cf"
include "VVRTypes.cf"
cluster rac_cluster102 (
UserNames = { admin = bopHo }
ClusterAddress = "10.11.10.102"
Administrators = { admin }
UseFence = SCSI3
)
remotecluster rac_cluster101 (
ClusterAddress = "10.10.10.101"
)
heartbeat Icmp (
ClusterList = { rac_cluster101 }
Arguments @rac_cluster101 = { "10.10.10.101" }
)
system mercury (
)
system jupiter (
)
group ClusterService (
SystemList = { mercury = 0, jupiter = 1 }
AutoStartList = { mercury, jupiter }
OnlineRetryLimit = 3
OnlineRetryInterval = 120
)
Application wac (
StartProgram = "/opt/VRTSvcs/bin/wacstart"
StopProgram = "/opt/VRTSvcs/bin/wacstop"
MonitorProcesses = { "/opt/VRTSvcs/bin/wac" }
RestartLimit = 3
)
IP gcoip (
Device = eth0
Address = "10.11.10.102"
NetMask = "255.255.240.0"
)
NIC csgnic (
Device = eth0
)
gcoip requires csgnic
wac requires gcoip
group RVGgroup (
SystemList = { mercury = 0, jupiter = 1 }
Parallel = 1
AutoStartList = { mercury, jupiter }
)
CVMVolDg racdata_voldg (
CVMDiskGroup = oradatadg
CVMActivation = sw
)
RVGShared racdata_rvg (
RVG = rac1_rvg
DiskGroup = oradatadg
)
requires group cvm online local firm
racdata_rvg requires racdata_voldg
group cvm (
SystemList = { mercury = 0, jupiter = 1 }
AutoFailOver = 0
Parallel = 1
AutoStartList = { mercury, jupiter }
)
Application cssd (
Critical = 0
StartProgram = "/opt/VRTSvcs/ops/bin/cssd-online"
StopProgram = "/opt/VRTSvcs/ops/bin/cssd-offline"
CleanProgram = "/opt/VRTSvcs/ops/bin/cssd-clean"
MonitorProgram = "/opt/VRTSvcs/ops/bin/cssd-monitor"
OnlineRetryLimit = 20
)
CFSfsckd vxfsckd (
)
CVMCluster cvm_clus (
CVMClustName = rac_cluster102
CVMNodeId = { mercury = 1, jupiter = 2 }
CVMTransport = gab
CVMTimeout = 200
)
CVMVolDg ocrvote_voldg (
Critical = 0
CVMDiskGroup = ocrvotedg
CVMVolume = { ocrvol, votevol }
CVMActivation = sw
)
CVMVxconfigd cvm_vxconfigd (
Critical = 0
CVMVxconfigdArgs = { syslog }
)
PrivNIC ora_privnic (
Critical = 0
Device = { eth0 = 0, eth1 = 1}
Address@galaxy = "192.168.12.1"
Address@nebula = "192.168.12.2"
NetMask = "255.255.240.0"
)
cssd requires ocrvote_voldg
cssd requires ora_priv
ocrvote_voldg requires cvm_clus
vxfsckd requires cvm_clus
cvm_clus requires cvm_vxconfigd
group oradb1_grp (
SystemList = { mercury = 0, jupiter = 1 }
Parallel = 1
ClusterList = { rac_cluster101 = 0, rac_cluster102 = 1 }
OnlineRetryInterval = 300
ClusterFailOverPolicy = Manual
Authority = 1
AutoStartList = { mercury, jupiter }
)
CFSMount oradata_mnt (
MountPoint = "/oradata"
BlockDevice = "/dev/vx/dsk/oradatadg/oradatavol"
)
Oracle ora1 (
Critical = 0
Sid @mercury = vrts1
Sid @jupiter = vrts2
Owner = oracle
Home = "/app/oracle/orahome"
StartUpOpt = SRVCTLSTART
ShutDownOpt = SRVCTLSTOP
)
RVGSharedPri ora_vvr_sharedpri (
RvgResourceName = racdata_rvg
OnlineRetryLimit = 0
)
requires group RVGgroup online local firm
ora1 requires oradata_mnt
oradata_mnt requires ora_vvr_sharedpri
group rlogowner (
SystemList = { mercury = 0, jupiter = 1 }
AutoStartList = { mercury, jupiter }
OnlineRetryLimit = 2
)
IP logowner_ip (
Device = eth0
Address = "10.11.9.102"
NetMask = "255.255.240.0"
)
NIC nic (
Device = eth0
)
RVGLogowner logowner (
RVG = rac1_rvg
DiskGroup = oradatadg
)
requires group RVGgroup online local firm
logowner requires logowner_ip
logowner_ip requires nic