一. 在主备机上安装Solaris8, Cluster 3.0 和 VXVM4.1, 过程略.
二. 在主机上安装Oracle, 过程略.备机的oracle不需要使用安装盘安装, 只需要拷贝主机的oracle即可,
以下过程会讲到.
三. 在主备机上安装oracle agent, 并注册cluster 资源
# scrgadm -a -t SUNW.oracle_server
# scrgadm -a -t SUNW.oracle_listener
# scrgadm -a -t SUNW.HAStoragePlus
四. 创建若干disk group.
1. 为oracle创建一个dg.
# vxdisk destroy c3t8d0
# vxdisksetup -i c3t8d0 format=sliced
# vxdg init oradg cds=off oradg01=c3t8d0
# vxdisk destroy c5t8d0
# vxdisksetup -i c5t8d0 format=sliced
# vxdg -g oradg adddisk oradg02=c5t8d0
# vxdisk list
DEVICE TYPE DISK GROUP STATUS
c1t0d0s2 auto:none - - online invalid
c1t2d0s2 auto:none - - online invalid
c1t3d0s2 auto:none - - online invalid
c3t8d0s2 auto:sliced oradg01 oradg online
c3t9d0s2 auto:sliced - - online
c3t10d0s2 auto:sliced - - online
c3t11d0s2 auto:sliced - - online
c3t12d0s2 auto:none - - online invalid
c5t8d0s2 auto:sliced oradg02 oradg online
c5t9d0s2 auto:sliced - - online
c5t10d0s2 auto:sliced - - online
c5t11d0s2 auto:sliced - - online
c5t12d0s2 auto:sliced - - online
2. Destroy elder mmsdg
# vxdisk destroy c3t9d0
# vxdisk destroy c3t10d0
# vxdisk destroy c3t11d0
# vxdisk destroy c5t9d0
# vxdisk destroy c5t10d0
# vxdisk destroy c5t11d0
3. Initiate disk for mmsdg.
# vxdisksetup -i c3t9d0 format=sliced
# vxdisksetup -i c3t10d0 format=sliced
# vxdisksetup -i c3t11d0 format=sliced
# vxdisksetup -i c5t9d0 format=sliced
# vxdisksetup -i c5t10d0 format=sliced
# vxdisksetup -i c5t11d0 format=sliced
4. create mmsdg.
# vxdg init mmsdg cds=off mmsdg01=c3t9d0
# vxdg -g mmsdg adddisk mmsdg02=c3t10d0
# vxdg -g mmsdg adddisk mmsdg03=c3t11d0
# vxdg -g mmsdg adddisk mmsdg04=c5t9d0
# vxdg -g mmsdg adddisk mmsdg05=c5t10d0
# vxdg -g mmsdg adddisk mmsdg06=c5t11d0
# vxdisk destroy c5t12d0
# vxdisksetup -i c5t12d0 format=sliced
# vxdg -g mmsdg adddisk mmsdg07=c5t12d0
# vxedit -g mmsdg set spare=on mmsdg07
5. 创建oracle 卷
# vxassist -g oradg -U gen make lv_system 2500M layout=mirror
# vxedit -g oradg set user=oracle group=dba mode=600 lv_system
# vxassist -g oradg -U gen make lv_undotdbs01 1000m layout=mirror &
# vxassist -g oradg -U gen make lv_undotdbs02 1000m layout=mirror &
# vxassist -g oradg -U gen make lv_undotdbs03 1000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_undotdbs01
# vxedit -g oradg set user=oracle group=dba mode=600 lv_undotdbs02
# vxedit -g oradg set user=oracle group=dba mode=600 lv_undotdbs03
# vxassist -g oradg -U gen make lv_drsys01 1000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_drsys01
# vxassist -g oradg -U gen make lv_example01 1000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_example01
# vxassist -g oradg -U gen make lv_index01 2000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_index01
# vxassist -g oradg -U gen make lv_odm01 1000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_odm01
# vxassist -g oradg -U gen make lv_tools01 2000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_tools01
# vxassist -g oradg -U gen make lv_users01 1000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_users01
# vxassist -g oradg -U gen make lv_xdb01 1000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_xdb01
# vxassist -g oradg -U gen make lv_cwm01 512m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_cwm01
# vxassist -g oradg -U gen make lv_temp01 2000m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_temp01
# vxassist -g oradg -U gen make lv_redo01 1200m layout=mirror &
# vxassist -g oradg -U gen make lv_redo02 1200m layout=mirror &
# vxassist -g oradg -U gen make lv_redo03 1200m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_redo01
# vxedit -g oradg set user=oracle group=dba mode=600 lv_redo02
# vxedit -g oradg set user=oracle group=dba mode=600 lv_redo03
# vxassist -g oradg -U gen make lv_control01 50m layout=mirror &
# vxassist -g oradg -U gen make lv_control02 50m layout=mirror &
# vxassist -g oradg -U gen make lv_control03 50m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_control01
# vxedit -g oradg set user=oracle group=dba mode=600 lv_control02
# vxedit -g oradg set user=oracle group=dba mode=600 lv_control03
# vxassist -g oradg -U gen make lv_spfile 50m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_spfile
6. 在cluster 注册oradg,和mmsdg, 此步非常重要,不注册无法正常使用vxvm卷.
# scconf -a -D type=vxvm,name=oradg,nodelist=mmsc1:mmsc2
# scconf -a -D type=vxvm,name=mmsdg,nodelist=mmsc1:mmsc2
# scconf -c -D name=oradg,sync
7. 在资源组mms_rg下创建若干资源
# scrgadm -a -g mms_rg
# scrgadm -a -L -g mms_rg -l mmsc_ip
# scrgadm -a -j oracle_dg -g mms_rg -t SUNW.HAStoragePlus -x GlobalDevicePaths=oradg -y Resource_dependencies=mmsc_ip
# scswitch -Z -g mms_rg
# scrgadm -a -j oracle_listener -g mms_rg -t SUNW.oracle_listener -x ORACLE_HOME=/opt/oracle/product/9.2 -y Resource_dependencies=oracle_dg
# scrgadm -a -j oracle_server -g mms_rg -t SUNW.oracle_server -x Connect_string="scott/nzclmmsc" -x ORACLE_SID="ora92" -x ORACLE_HOME="/opt/oracle/product/9.2" -x Alert_log_file="/opt/oracle/admin/ora92/bdump/alert_ora92.log" -y Resource_dependencies=oracle_listener
8. 为应用程序创建若干卷
# vxassist -g oradg -U gen make lv_oravol01 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol02 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol03 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol04 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol05 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol06 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol07 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol08 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol09 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol10 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol11 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol12 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol13 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol14 2200m layout=mirror &
# vxassist -g oradg -U gen make lv_oravol15 2200m layout=mirror &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol01 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol02 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol03 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol04 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol05 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol06 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol07 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol08 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol09 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol10 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol11 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol12 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol13 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol14 &
# vxedit -g oradg set user=oracle group=dba mode=600 lv_oravol15 &
# scconf -c -D name=mmsdg,sync
9.连接到oracle, 创建应用表空间
CREATE TABLESPACE MMSC LOGGING DATAFILE '/dev/vx/rdsk/oradg/lv_oravol01' SIZE 2000m;
CREATE TEMPORARY TABLESPACE MMSC_TMP tempfile '/dev/vx/rdsk/oradg/lv_oravol02' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol03' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol04' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol05' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol06' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol07' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol08' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol09' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol10' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol11' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol12' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol13' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol14' SIZE 2000m;
ALTER TABLESPACE MMSC ADD DATAFILE '/dev/vx/rdsk/oradg/lv_oravol15' SIZE 2000m;
在主机上停掉oracle, 把oracle家目录tar出来,复制到备机相应目录进行安装.
10.注册双机监控脚本
cp /opt/HWmms/etc/HW.mms /usr/cluster/lib/rgm/rtreg
scrgadm -a -t HW.mm
11. 在/etc/vfstab 增加如下内容
/dev/vx/dsk/mmsdg/lv_cfg /dev/vx/rdsk/mmsdg/lv_cfg /ShareDisks/mmsc_cfg/cfg/ ufs 1 no -
/dev/vx/dsk/mmsdg/lv_cdr /dev/vx/rdsk/mmsdg/lv_cdr /ShareDisks/mmsc_cdr ufs 1 no -
/dev/vx/dsk/mmsdg/lv_mmstore /dev/vx/rdsk/mmsdg/lv_mmstore /ShareDisks/mmsc_mmstore/store/ ufs 1 no -
/dev/vx/dsk/mmsdg/lv_npdata /dev/vx/rdsk/mmsdg/lv_npdata /ShareDisks/mmsc_npdata ufs 1 no -
/dev/vx/dsk/mmsdg/lv_log /dev/vx/rdsk/mmsdg/lv_log /ShareDisks/mmsc_log ufs 1 no -
12.
下面的FilesystemMountPoints的目录顺序必须和vfstab的顺序保持一致, 否则执行失败.
scrgadm -a -j mms_dg -g mms_rg -t SUNW.HAStoragePlus -x GlobalDevicePaths=mmsdg -x FilesystemMountPoints=/ShareDisks/mmsc_cfg/cfg,/ShareDisks/mmsc_cdr,/ShareDisks/mmsc_mmstore/store,/ShareDisks/mmsc_npdata,/ShareDisks/mmsc_log
