This section describes how to create database tablespace on shared raw VxVM volumes (option 1).
To create database tablespace on shared raw VxVM volumes (option 1)
Find out the CVM master, enter the following command on any node:
# vxdctl -c mode mode: enabled: cluster active - MASTER master: system01
The above sample output indicates that system01 is the CVM master.
On the CVM master, find out the spare disks that can be used for creating shared disk group for Oracle database tablespaces, enter:
# vxdisk -o alldgs list DEVICE TYPE DISK GROUP STATUS hdisk1 auto:none - - online invalid hdisk2 auto:none - - online invalid hdisk3 auto:cdsdisk - tempdg online shared hdisk4 auto:none - ocrvotedg online shared hdisk5 auto:cdsdisk - - online shared hdisk6 auto:cdsdisk - - online shared
The above sample output indicates that shared disks sde and sdf are free and can be used for Oracle database tablespaces.
On the CVM master node, create a shared disk group:
# vxdg -s init oradatadg hdisk5 hdisk6
Create a volume in the shared group for each of the required tablespaces.
See the Oracle documentation specific to the Oracle database release to determine the tablespace requirements.
# vxassist -g oradatadg make VRT_system01 1000M # vxassist -g oradatadg make VRT_system02 10M . . .
Define the access mode and permissions for the volumes storing the Oracle data. For each volume listed in $ORACLE_HOME/raw_config
, use the vxedit command:
# vxedit -g disk_group set group=group user=user mode=660 volume
See the vxedit
(1M) manual page.
# vxedit -g oradatadg set group=oinstall user=oracle mode=660 VRT_system01
In this example, VRT_system01 is the name of one of the volumes. Repeat the command to define access mode and permissions for each volume in the oradatadg.