ORACLE 10.2.0.5 RAC OCR&vote disk 磁碟遷移 DG Rebalance測試

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/，如需轉載，請註明出處，否則將追究法律責任。

ORACLE 10.2.0.5 RAC OCR&vote disk 磁碟遷移 DG Rebalance測試

相關文章