11GR2在线迁移OCR&VOTEDISK

环境
操作系统         RHEL 5.5
数据库             ORACLE  11.2.0.1.0
现有磁盘组     OCR ,DATA （OCR 存放 ocr+votedisk  DATA存放数据）
新增磁盘组       OCRBAK （用于迁移OCR&VOTEDISK&asmSPFILE ）


在线迁移 OCR
[root@jxdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2692
         Available space (kbytes) :     259428
         ID                       : 1673930413
         Device/File Name         :       +ocr
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
SQL> select v1.name,v2.failgroup,v2.failgroup_type,v2.total_mb,v2.free_mb
  2  from v$asm_diskgroup v1,v$asm_disk v2
  3  where v1.group_number=v2.group_number
  4  and  v1.name='OCRBAK';

NAME                 FAILGROUP     FAILGROUP_TYPE          TOTAL_MB    FREE_MB
-------------------- ------------- --------------------- ---------- ----------
OCRBAK               OCRBAK_0002   REGULAR                     1019        924
OCRBAK               OCRBAK_0001   REGULAR                     1019        924
OCRBAK               OCRBAK_0000   REGULAR                     1019        924

[root@jxdb1 ~]# ocrconfig -add +ocrbak
SQL> /    （增加 ocr后）

NAME                 FAILGROUP     FAILGROUP_TYPE          TOTAL_MB    FREE_MB
-------------------- ------------- --------------------- ---------- ----------
OCRBAK               OCRBAK_0002   REGULAR                     1019        743
OCRBAK               OCRBAK_0001   REGULAR                     1019        743
OCRBAK               OCRBAK_0000   REGULAR                     1019        743
[root@jxdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2692
         Available space (kbytes) :     259428
         ID                       : 1673930413
         Device/File Name         :       +ocr
                                    Device/File integrity check succeeded
         Device/File Name         :    +ocrbak
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
[root@jxdb1 ~]# ocrconfig -delete +ocr
[root@jxdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2692
         Available space (kbytes) :     259428
         ID                       : 1673930413
         Device/File Name         :    +ocrbak
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
迁移成功 ocr.loc文件自动更新ocr路径 ,不需要 手动更新。


在线迁移 VOTE DISK
[root@jxdb1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   4bec684119014fdabf286e3a521f5c34 (/dev/raw/raw1) [OCR]
 2. ONLINE   021fab5600c24f0ebf2bd281e7601830 (/dev/raw/raw2) [OCR]
 3. ONLINE   6fbd650413c94f5abf75e59518108517 (/dev/raw/raw3) [OCR]
Located 3 voting disk(s).
[root@jxdb1 ~]# crsctl replace votedisk +ocrbak
Successful addition of voting disk 72d8621e1d204f06bf42ecb8020de39d.
Successful addition of voting disk b0672f055d514f41bf4d2593fb1bc10f.
Successful addition of voting disk 2a5828e258554f23bf82093fe2f1d191.
Successful deletion of voting disk 4bec684119014fdabf286e3a521f5c34.
Successful deletion of voting disk 021fab5600c24f0ebf2bd281e7601830.
Successful deletion of voting disk 6fbd650413c94f5abf75e59518108517.
Successfully replaced voting disk group with +ocrbak.
CRS-4266: Voting file(s) successfully replaced
[root@jxdb1 ~]# crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   72d8621e1d204f06bf42ecb8020de39d (/dev/raw/raw7) [OCRBAK]
 2. ONLINE   b0672f055d514f41bf4d2593fb1bc10f (/dev/raw/raw8) [OCRBAK]
 3. ONLINE   2a5828e258554f23bf82093fe2f1d191 (/dev/raw/raw9) [OCRBAK]
Located 3 voting disk(s).

SQL> /   （增加 votedisk后）

NAME                 FAILGROUP     FAILGROUP_TYPE          TOTAL_MB    FREE_MB
-------------------- ------------- --------------------- ---------- ----------
OCRBAK               OCRBAK_0002   REGULAR                     1019        711
OCRBAK               OCRBAK_0001   REGULAR                     1019        711
OCRBAK               OCRBAK_0000   REGULAR                     1019        711
迁移成功

检查RAC是否正常运行
[root@jxdb1 ~]# crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    jxdb1      
ora....ER.lsnr ora....er.type ONLINE    ONLINE    jxdb1      
ora....N1.lsnr ora....er.type ONLINE    ONLINE    jxdb1      
ora.OCR.dg     ora....up.type ONLINE    ONLINE    jxdb1      
ora.OCRBAK.dg  ora....up.type ONLINE    ONLINE    jxdb1      
ora.asm        ora.asm.type   ONLINE    ONLINE    jxdb1      
ora.eons       ora.eons.type  ONLINE    ONLINE    jxdb1      
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora.jxdb.db    ora....se.type ONLINE    ONLINE    jxdb1      
ora....SM1.asm application    ONLINE    ONLINE    jxdb1      
ora....B1.lsnr application    ONLINE    ONLINE    jxdb1      
ora.jxdb1.gsd  application    OFFLINE   OFFLINE              
ora.jxdb1.ons  application    ONLINE    ONLINE    jxdb1      
ora.jxdb1.vip  ora....t1.type ONLINE    ONLINE    jxdb1      
ora....SM2.asm application    ONLINE    ONLINE    jxdb2      
ora....B2.lsnr application    ONLINE    ONLINE    jxdb2      
ora.jxdb2.gsd  application    OFFLINE   OFFLINE              
ora.jxdb2.ons  application    ONLINE    ONLINE    jxdb2      
ora.jxdb2.vip  ora....t1.type ONLINE    ONLINE    jxdb2      
ora....network ora....rk.type ONLINE    ONLINE    jxdb1      
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE              
ora.ons        ora.ons.type   ONLINE    ONLINE    jxdb1      
ora....ry.acfs ora....fs.type ONLINE    ONLINE    jxdb1      
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jxdb1      
一切正常


将ASM实例的参数文件迁移到新磁盘组
1，查看 ASM实例的参数文件位置（不要把 ASM实例与应用实例搞混）
jxdb1:/home/grid$sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 25 15:57:49 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter spfile
NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
spfile                               string
+OCR/jxdb-cluster/asmparameter
file/registry.253.802107497

2，备份 ASM实例参数文件
SQL> create pfile='/tmp/asmpfile' from spfile;

3，在新磁盘组上创建 ASM实例的SPFILE
SQL> create spfile='+OCRBAK ' from pfile='/tmp/asmpfile';

4，重启 CRS使新SPFILE 生效（如果数据库繁忙可能需要较长的停机时间）
[root@jxdb1 ~]# crsctl stop crs
[root@jxdb1 ~]# crsctl start crs
[root@jxdb2 ~]# crsctl stop crs
[root@jxdb2 ~]# crsctl start crs

5，检查 ASM实例的SPFILE 是否迁移成功
SQL> show parameter spfile
NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
spfile                               string
+OCRBAK /jxdb-cluster/asmparame
terfile/registry.253.802972767
成功，实例正常运行。
删除多余磁盘组
[root@jxdb1 ~]# su - grid
jxdb1:/home/grid$sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 25 16:27:37 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> drop diskgroup ocr;
drop diskgroup ocr
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "OCR" contains existing files

SQL> drop diskgroup ocr including contents;
Diskgroup dropped.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26179376/viewspace-1981730/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26179376/viewspace-1981730/