Oracle11gR2RACwithASM存储迁移-手记分析.docxVIP

Oracle 11g R2 RAC with ASM存储迁移【手记】2016.06【摘要】Oracle数据库文件部署在ASM上，需要尽量短的停机时间完成此次存储更换。由于不涉及异构的迁移转换，迁移起来也不难，无需借助三方的工具来完成这次高可用切换。因此使用迁移ASM DISKGROUP 的方式完成存储迁移，?该方法实现迁移过程中尽量缩短系统的停机时间。【正文】首先，介绍迁移的简单过程。步骤如下：划分asm disk，并检查或更改UDEV配置文件，使得新存储的asm disk对ASM实例可识别。备份OCR、Voting Disk、ASM disk header和数据库。创建新的DISKGROUP迁移OCR和Vote Disks到新磁盘组（ASM diskgroup）迁移ASM Spfile到新磁盘组（ASM diskgroup）迁移数据库相关文件至新磁盘组（ASM diskgroup）在线修改数据库参数文件（归档路径、闪回等）删除旧磁盘组观察期。执行数据库备份本文重点介绍ASM的热添加和删除磁盘技术，所以第1、2步在此不列出，由第3步开始。一、添加ASM磁盘组下面开始添加asm磁盘，这里使用ASM的REBALANCE技术来解决在线迁移数据。查看当前ASM磁盘信息登录到ASM实例，查看当前磁盘组的信息：[[grid@rac1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 22 09:08:26 2016Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL select instance_name from v$instance;INSTANCE_NAME----------------+ASM1SQL col name for a10SQL set linesize 150SQL select NAME, ALLOCATION_UNIT_SIZE, STATE, TOTAL_MB, FREE_MB USABLE_FILE_MB from gv$asm_diskgroup;NAME ALLOCATION_UNIT_SIZE STATE TOTAL_MB USABLE_FILE_MB---------- -------------------- ----------- ---------- --------------DATA 1048576 MOUNTED 10240 6721FRA 1048576 MOUNTED 13312 11081SYSTEMDG 1048576 MOUNTED 25600 24344DATA 1048576 MOUNTED 10240 6721FRA 1048576 MOUNTED 13312 11081SYSTEMDG 1048576 MOUNTED 25600 243446 rows selected.SQL select failgroup, name from v$asm_disk where group_number=(select group_number from v$asm_diskgroup where name = DATA);FAILGROUP NAME------------------------------ ----------DATA_0001 DATA_0001DATA_0000 DATA_0000利用asmca命令创建DISKGROUP相关的sql语句SQL CREATE DISKGROUP DATA2 EX