oracle RAC 在线更换存储迁移数据.docx

oracle RAC 在线更换存储迁移数据.docx

《oracle RAC 在线更换存储迁移数据.docx》由会员分享，可在线阅读，更多相关《oracle RAC 在线更换存储迁移数据.docx（19页珍藏版）》请在冰点文库上搜索。

oracleRAC在线更换存储迁移数据

oracleRAC更换存储迁移数据

我们利用ASMrebalance特性实现更换存储迁移数据的需求

基本零宕机时间（操作步骤总结）

1）保证新存储和RAC当前节点间的可用性；

2）新存储划分LUN，可以重新规划存储方案；

3）迁移OCR和表决盘

4）给现有ASM磁盘组添加ASM磁盘（新存储分配的），充分利用ASMREBALANCE技术

5）删除原存储的ASM磁盘

6）观察期

 1当前存储信息

以下ASM磁盘组、OCR、VOTE信息：

ASM磁盘组：

ASMCMD>lsdg

State  Type  Rebal Sector Block   AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED NORMAL N    512 4096 1048576 3071982 3071091       298    1535396       0      N BACK/

MOUNTED NORMAL N    512 4096 1048576 4095976 1561759     633568     464095       0      N DATA/

MOUNTED NORMAL N    512 4096 1048576  102396 101470       326     50572       0      N OCR/

当前ASM有BACK，DATA，OCR三个磁盘组，总大小7TB，磁盘组主要存放数据文件和归档日志文件，COR文件，以下是各磁盘组磁盘信息：

SQL>selectNAME,PATH,total_mb,free_mbfromv$asm_disk;

NAME             PATH              TOTAL_MB  FREE_MB

--------------------------------------------------------------------------------

BACK_VOL1           ORCL:

BACK_VOL1          1023994  390436

DATA_VOL1           ORCL:

DATA_VOL1          1023994  390450

DATA_VOL2           ORCL:

DATA_VOL2          1023994  390447

DATA_VOL3           ORCL:

DATA_VOL3          1023994  390426

DATA_VOL4           ORCL:

DATA_VOL4          1023994  1023697

DATA_VOL5           ORCL:

DATA_VOL5          1023994  1023698

DATA_VOL6           ORCL:

DATA_VOL6          1023994  1023696

OCR_VOL1           ORCL:

OCR_VOL1           31376   31075

OCR_VOL2           ORCL:

OCR_VOL2           31376   31077

OCR_VOL3           ORCL:

OCR_VOL3           39644   39318

10rowsselected.

OCR&VOTE信息：

[grid@oracle1bin]$./ocrcheck

StatusofOracleClusterRegistryisasfollows:

     Version         :

     3

     Totalspace（kbytes）  :

  262120

     Usedspace（kbytes）   :

   2720

     Availablespace（kbytes）:

  259400

     ID           :

2006438789

     Device/FileName    :

   +OCR

                  Device/Fileintegritychecksucceeded

                  Device/Filenotconfigured

                  Device/Filenotconfigured

                  Device/Filenotconfigured

                  Device/Filenotconfigured

     Clusterregistryintegritychecksucceeded

     Logicalcorruptioncheckbypassedduetonon-privilegeduser

     由于OCR和VOTEDISK都和ASM放在同一个存储上，所以OCR和VOTEDISK也需要迁移到新的存储上。

2新存储磁盘分区

要求：

（由存储工程师操作）

2.1.共享存储，两台服务器都可以看到新存储分配的磁盘空间。

2.2.如之前ASM磁盘组所有存储分区大小，个数保持一致。

3划分后磁盘分区

[root@oracle1sbin]#fdisk-l

Disk/dev/cciss/c0d0:

1000.1GB,1000171331584bytes

255heads,63sectors/track,121597cylinders

Units=cylindersof16065*512=8225280bytes

      DeviceBoot   Start    End   Blocks Id System

/dev/cciss/c0d0p1 *     1     13   104391 83 Linux

/dev/cciss/c0d0p2       14   121597 976623480 8e LinuxLVM

Disk/dev/sda:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sda1       1   130541 1048570551 83 Linux

Disk/dev/sdb:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdb1       1   130541 1048570551 83 Linux

Disk/dev/sdc:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdc1       1   130541 1048570551 83 Linux

Disk/dev/sdd:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdd1       1   130541 1048570551 83 Linux

Disk/dev/sde:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sde1       1   130541 1048570551 83 Linux

Disk/dev/sdf:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdf1       1   130541 1048570551 83 Linux

Disk/dev/sdg:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdg1       1   130541 1048570551 83 Linux

Disk/dev/sdh:

107.3GB,107374182400bytes

255heads,63sectors/track,13054cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdh1       1    4000  32129968+ 83 Linux

/dev/sdh2      4001    8000  32130000 83 Linux

/dev/sdh3      8001   13054  40596255 83 Linux

WARNING:

Thesizeofthisdiskis2.9TB（2919504019456bytes）.

DOSpartitiontableformatcannotbeusedondrivesforvolumes

largerthan2.2TB（2199023255040bytes）.Useparted

（1）andGUID 

partitiontableformat（GPT）.

Disk/dev/sdi:

2919.5GB,2919504019456bytes

255heads,63sectors/track,354942cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdi1       1   130000 1044224968+ 83 Linux

/dev/sdi2     130001   267349 1103255842+ 83 Linux

Disk/dev/sdj:

1073.7GB,1073741824000bytes --------------------------------新加盘

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdjdoesn'tcontainavalidpartitiontable

Disk/dev/sdk:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdkdoesn'tcontainavalidpartitiontable

Disk/dev/sdl:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdldoesn'tcontainavalidpartitiontable

Disk/dev/sdm:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdmdoesn'tcontainavalidpartitiontable

Disk/dev/sdn:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdndoesn'tcontainavalidpartitiontable

Disk/dev/sdo:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdodoesn'tconainavalidpartitiontable

Disk/dev/sdp:

1073.7GB,1073741824000bytes

255heads,63sectors/track,130541cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdpdoesn'tcontainavalidpartitiontable

Disk/dev/sdq:

107.3GB,107374182400bytes

255heads,63sectors/track,13054cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdqdoesn'tcontainavalidpartitiontable

Disk/dev/sdr:

2919.5GB,2919504019456bytes

255heads,63sectors/track,354942cylinders

Units=cylindersof16065*512=8225280bytes

Disk/dev/sdrdoesn'tcontainavalidpartitiontable

Disk/dev/sds:

322.1GB,322122547200bytes

255heads,63sectors/track,39162cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sds1       1   39162 314568733+ 8e LinuxLVM

Disk/dev/sdt:

322.1GB,322122547200bytes

255heads,63sectors/track,39162cylinders

Units=cylindersof16065*512=8225280bytes

  DeviceBoot   Start    End   Blocks Id System

/dev/sdt1       1   39162 314568733+ 8e LinuxLVM

4配置ASM新磁盘

/etc/init.d/oracleasmcreatediskDATA_VOL01/dev/sdj1

/etc/init.d/oracleasmcreatediskDATA_VOL02/dev/sdk1

/etc/init.d/oracleasmcreatediskDATA_VOL03/dev/sdl1

/etc/init.d/oracleasmcreatediskDATA_VOL04/dev/sdm1

/etc/init.d/oracleasmcreatediskDATA_VOL05/dev/sdn1

/etc/init.d/oracleasmcreatediskDATA_VOL06/dev/sdo1

/etc/init.d/oracleasmcreatediskBACK_VOL01/dev/sdp1

/etc/init.d/oracleasmcreatediskOCR_VOL4/dev/sdq1

/etc/init.d/oracleasmcreatediskOCR_VOL5/dev/sdq2

/etc/init.d/oracleasmcreatediskOCR_VOL6/dev/sdq3

5创建新的OCRNEW磁盘组

su–grid

sqlplus/assysasm

CREATEDISKGROUPOCRNEWNORMALREDUNDANCY 

DISK'ORCL:

OCR_VOL4'NAMEVOL4

DISK'ORCL:

OCR_VOL5'NAMEVOL5

DISK'ORCL:

OCR_VOL6'NAMEVOL6ATTRIBUTE'compatible.asm'='11.2';

6添加OCR信息到OCRNEW 

 [root@oracle1bin]#./ocrconfig-add +OCRNEW

 [root@oracle1bin]#./ocrcheck-config

OracleClusterRegistryconfigurationis:

     Device/FileName    :

   +OCR

     Device/FileName    :

  +OCRNEW

[root@oracle1bin]#more/etc/oracle/ocr.loc

#Device/file gettingreplacedbydevice+OCRNEW 

ocrconfig_loc=+OCR

ocrmirrorconfig_loc=+OCRNEW

local_only=false

[root@oracle1bin]#

可以看到OCRNEW磁盘组已经成功添加到OCR磁盘信息中

迁移vote文件

当前votedisk信息

[grid@oracle1~]$crsctlquerycssvotedisk 

## STATE  FileUniversalId        Fil