1 OCR 迁移
查看 ocr vote disk信息
[root@10grac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 204560
Used space (kbytes) : 3860
Available space (kbytes) : 200700
ID : 2010075016
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
Cluster registry integrity check succeeded
[root@10grac1 ~]# crsctl query css votedisk
0. 0 /dev/raw/raw5
1. 0 /dev/raw/raw6
2. 0 /dev/raw/raw7
开始Ocr信息迁移
我们系统现有其他的磁盘叫raw3 ,raw4 计划把ocr信息在线迁移到 这两块盘。
#ocrconfig -replace ocr /dev/raw/raw3
[root@10grac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 204560
Used space (kbytes) : 3860
Available space (kbytes) : 200700
ID : 2010075016
Device/File Name : /dev/raw/raw3
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw2
Device/File integrity check succeeded
#ocrconfig -replace ocrmirror /dev/raw/raw4
-bash: ocrccheck: command not found
[root@10grac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 204560
Used space (kbytes) : 3860
Available space (kbytes) : 200700
ID : 2010075016
Device/File Name : /dev/raw/raw3
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw4
Device/File integrity check succeeded
Cluster registry integrity check succeeded
[root@10grac1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 204560
Used space (kbytes) : 3868
Available space (kbytes) : 200692
ID : 2010075016
Device/File Name : /dev/raw/raw3
Device/File integrity check succeeded
Device/File Name : /dev/raw/raw4
Device/File integrity check succeeded
Cluster registry integrity check succeeded
Vote迁移
查看当前vote 磁盘信息,我们打算把vote 迁移到raw8,raw9 ,raw10上,然后删除老的raw5,raw6,raw7
[root@10grac1 ~]# crsctl query css votedisk
0. 0 /dev/raw/raw5
1. 0 /dev/raw/raw6
2. 0 /dev/raw/raw7
located 3 votedisk(s).
增加新的vote 磁盘 我们这里增加三块 raw8 raw9 raw10
[root@10grac1 ~]# crsctl add css votedisk /dev/raw/raw8 -force
Now formatting voting disk: /dev/raw/raw8
successful addition of votedisk /dev/raw/raw8.
located 4 votedisk(s).
[root@10grac1 ~]# crsctl add css votedisk /dev/raw/raw9 -force
Now formatting voting disk: /dev/raw/raw9
successful addition of votedisk /dev/raw/raw9.
[root@10grac1 ~]#
[root@10grac1 ~]# crsctl add css votedisk /dev/raw/raw10 -force
Now formatting voting disk: /dev/raw/raw10
successful addition of votedisk /dev/raw/raw10.
[root@10grac1 ~]# crsctl query css votedisk
0. 0 /dev/raw/raw5
1. 0 /dev/raw/raw6
2. 0 /dev/raw/raw7
3. 0 /dev/raw/raw8
4. 0 /dev/raw/raw9
5. 0 /dev/raw/raw10
删除老的vote disk 磁盘
[root@10grac1 ~]# crsctl delete css votedisk /dev/raw/raw5 -force
successful deletion of votedisk /dev/raw/raw5.
[root@10grac1 ~]#
[root@10grac1 ~]# crsctl delete css votedisk /dev/raw/raw6 -force
successful deletion of votedisk /dev/raw/raw6.
[root@10grac1 ~]#
[root@10grac1 ~]# crsctl delete css votedisk /dev/raw/raw7 -force
successful deletion of votedisk /dev/raw/raw7.
[root@10grac1 ~]# crsctl query css votedisk
0. 0 /dev/raw/raw8
1. 0 /dev/raw/raw9
2. 0 /dev/raw/raw10
数据文件rebalance,环境是原来fidg中有三个failgroup(sto1,sto2,sto3)做的是normal冗余,我们计划把数据文件rebalance 到新加的三个failgroup sto4,sto5,sto6上。
首先在原来fiodg中增加三个failgroup ,老的failgroup 为sto1 sto2 sto3
alter DISKGROUP fiodg add
FAILGROUP sto4 DISK
'/dev/raw/raw17',
'/dev/raw/raw18'
FAILGROUP sto5 DISK
'/dev/raw/raw19',
'/dev/raw/raw20'
FAILGROUP sto6 DISK
'/dev/raw/raw21',
'/dev/raw/raw22';
增加完成后我们在数据库创建数据文件,插入数据
然后drop 旧的failgroup sto1,sto2,sto3 中disks
ALTER DISKGROUP fiodg drop DISKS IN FAILGROUP sto1;
ALTER DISKGROUP fiodg drop DISKS IN FAILGROUP sto2;
ALTER DISKGROUP fiodg drop DISKS IN FAILGROUP sto3;
我们看到有重平衡在操作,等重平衡之后我可以升级存储os。
SQL> /
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- ---- ---------- ---------- ---------- ---------- ---------- -----------
1 REBAL REAP 11 4 667 1352 493 1
GROUP_NUMBER GNAME STATE TOTAL_MB TYPE DISK_NUMBER STATE DNAME DMB PATH FAILGROUP
------------ ---------- ----------- ---------- ------ ----------- -------- --------------- ---------- ------------------------------------------ -------------------
1 FIODG MOUNTED 5880 NORMAL 11 NORMAL FIODG_0011 980 /dev/raw/raw22 STO6
1 FIODG MOUNTED 5880 NORMAL 8 NORMAL FIODG_0008 980 /dev/raw/raw19 STO5
1 FIODG MOUNTED 5880 NORMAL 7 NORMAL FIODG_0007 980 /dev/raw/raw18 STO4
1 FIODG MOUNTED 5880 NORMAL 9 NORMAL FIODG_0009 980 /dev/raw/raw20 STO5
1 FIODG MOUNTED 5880 NORMAL 10 NORMAL FIODG_0010 980 /dev/raw/raw21 STO6
1 FIODG MOUNTED 5880 NORMAL 6 NORMAL FIODG_0006 980 /dev/raw/raw17 STO4
整个过程中集群一直是正常。
root@10grac1 ~]# crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE 10grac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE 10grac1
ora....ac1.gsd application 0/5 0/0 ONLINE ONLINE 10grac1
ora....ac1.ons application 0/3 0/0 ONLINE ONLINE 10grac1
ora....ac1.vip application 0/0 0/0 ONLINE ONLINE 10grac1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE 10grac2
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE 10grac2
ora....ac2.gsd application 0/5 0/0 ONLINE ONLINE 10grac2
ora....ac2.ons application 0/3 0/0 ONLINE ONLINE 10grac2
ora....ac2.vip application 0/0 0/0 ONLINE ONLINE 10grac2
ora.rac.db application 0/0 0/1 ONLINE ONLINE 10grac1
ora....c1.inst application 0/5 0/0 ONLINE ONLINE 10grac1
ora....c2.inst application 0/5 0/0 ONLINE ONLINE 10grac2
总结
?整个测试接近生产环境,整个操作流程没有出现问题。但是问题是在生产环境 替换VOTE 的时候会引起无规律的css shutdown
官方文档如下描述,看来生产环境还是要停机。
crsctl add css votedisk path
Run the following command as the root user to remove a voting disk:
crsctl delete css votedisk path
Note:
Bring down ocssd using the -force option prior to modifying the voting disk configuration with either of these commands to avoid interacting with active Oracle Clusterware daemons. Note also that using the -force option while any cluster node is active may corrupt your configuration.来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26175573/viewspace-2057438/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26175573/viewspace-2057438/