oracle RAC 在线更换存储迁移数据.docx
- 文档编号:24435551
- 上传时间:2023-05-27
- 格式:DOCX
- 页数:19
- 大小:19.25KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle RAC 在线更换存储迁移数据 在线 更换 存储 迁移 数据