Oracle 11g R2 RAC with ASM存储迁移手记.docx
《Oracle 11g R2 RAC with ASM存储迁移手记.docx》由会员分享，可在线阅读，更多相关《Oracle 11g R2 RAC with ASM存储迁移手记.docx（29页珍藏版）》请在冰豆网上搜索。
Oracle11gR2RACwithASM存储迁移手记
Oracle11gR2RACwithASM存储迁移【手记】
2016.06
【摘要】
Oracle数据库文件部署在ASM上，需要尽量短的停机时间完成此次存储更换。
由于不涉及异构的迁移转换，迁移起来也不难，无需借助三方的工具来完成这次高可用切换。
因此使用迁移ASMDISKGROUP的方式完成存储迁移， 该方法实现迁移过程中尽量缩短系统的停机时间。
【正文】
首先，介绍迁移的简单过程。
步骤如下：
1）划分asmdisk，并检查或更改UDEV配置文件，使得新存储的asmdisk对ASM实例可识别。
2）备份OCR、VotingDisk、ASMdiskheader和数据库。
3）创建新的DISKGROUP
4）迁移OCR和VoteDisks到新磁盘组（ASMdiskgroup）
5）迁移ASMSpfile到新磁盘组（ASMdiskgroup）
6）迁移数据库相关文件至新磁盘组（ASMdiskgroup）
7）在线修改数据库参数文件（归档路径、闪回等）
8）删除旧磁盘组
9）观察期。
10）执行数据库备份
本文重点介绍ASM的热添加和删除磁盘技术，所以第1、2步在此不列出，由第3步开始。
一、添加ASM磁盘组
下面开始添加asm磁盘，这里使用ASM的REBALANCE技术来解决在线迁移数据。
查看当前ASM磁盘信息
登录到ASM实例，查看当前磁盘组的信息：
[[grid@rac1~]$sqlplus/assysasm
SQL*Plus:
Release11.2.0.3.0ProductiononWedJun2209:
08:
262016
Copyright（c）1982,2011,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions
SQL>selectinstance_namefromv$instance;
INSTANCE_NAME
----------------
+ASM1
SQL>colnamefora10
SQL>setlinesize150
SQL>selectNAME,ALLOCATION_UNIT_SIZE,STATE,TOTAL_MB,FREE_MBUSABLE_FILE_MBfromgv$asm_diskgroup;
NAMEALLOCATION_UNIT_SIZESTATETOTAL_MBUSABLE_FILE_MB
-----------------------------------------------------------------
DATA1048576MOUNTED102406721
FRA1048576MOUNTED1331211081
SYSTEMDG1048576MOUNTED2560024344
DATA1048576MOUNTED102406721
FRA1048576MOUNTED1331211081
SYSTEMDG1048576MOUNTED2560024344
6rowsselected.
SQL>selectfailgroup,namefromv$asm_diskwheregroup_number=（selectgroup_numberfromv$asm_diskgroupwherename='DATA'）;
FAILGROUPNAME
----------------------------------------
DATA_0001DATA_0001
DATA_0000DATA_0000
利用asmca命令创建DISKGROUP
相关的sql语句
SQL>CREATEDISKGROUPDATA2EXTERNALREDUNDANCYDISK'/dev/asm-diskk'SIZE20480MATTRIBUTE'compatible.asm'='11.2.0.0.
0','au_size'='1M'/*ASMCA*/
SQL>CREATEDISKGROUPFRA2EXTERNALREDUNDANCYDISK'/dev/asm-diskl'SIZE5120MATTRIBUTE'compatible.asm'='11.2.0.0.0'
'au_size'='1M'/*ASMCA*/
磁盘组状态
ora.DATA.dg
ONLINEONLINErac1
ONLINEONLINErac2
ora.DATA2.dg
ONLINEONLINErac1
ONLINEONLINErac2
ora.FRA.dg
ONLINEONLINErac1
ONLINEONLINErac2
ora.FRA2.dg
ONLINEONLINErac1
ONLINEONLINErac2
ora.LISTENER.lsnr
ONLINEONLINErac1
ONLINEOFFLINErac2
ora.SYSTEMDG.dg
ONLINEONLINErac1
ONLINEONLINErac2
ora.asm
ONLINEONLINErac1Started
ONLINEONLINErac2Started
[grid@rac1~]$sqlplus/assysdba
SQL*Plus:
Release11.2.0.3.0ProductiononWedJun2210:
02:
372016
Copyright（c）1982,2011,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions
SQL>selectname,statefromv$asm_diskgroup;
NAMESTATE
-----------------------------------------
DATAMOUNTED
FRAMOUNTED
SYSTEMDGMOUNTED
DATA2MOUNTED
FRA2MOUNTED
二、迁移OCR和VoteDisks到新磁盘组（ASMdiskgroup）
查看ocr信息：
[grid@rac1~]$ocrcheck
StatusofOracleClusterRegistryisasfollows:
Version:
3
Totalspace（kbytes）:
262120
Usedspace（kbytes）:
2916
Availablespace（kbytes）:
259204
ID:
997200134
Device/FileName:
+SYSTEMDG
Device/Fileintegritychecksucceeded
Device/Filenotconfigured
Device/Filenotconfigured
Device/Filenotconfigured
Device/Filenotconfigured
Clusterregistryintegritychecksucceeded
Logicalcorruptioncheckbypassedduetonon-privilegeduser
添加ocr磁盘组
[root@rac1bin]#./ocrconfig-add+DATA2
[root@rac1bin]#./ocrcheck
StatusofOracleClusterRegistryisasfollows:
Version:
3
Totalspace（kbytes）:
262120
Usedspace（kbytes）:
2916
Availablespace（kbytes）:
259204
ID:
997200134
Device/FileName:
+SYSTEMDG
Device/Fileintegritychecksucceeded
Device/FileName:
+DATA2
Device/Fileintegritychecksucceeded
Device/Filenotconfigured
Device/Filenotconfigured
Device/Filenotconfigured
Clusterregistryintegritychecksucceeded
Logicalcorruptionchecksucceeded
删除OCR旧磁盘组
[root@rac1bin]#./ocrconfig-delete+SYSTEMDG
[root@rac1bin]#./ocrcheck
StatusofOracleClusterRegistryisasfollows:
Version:
3
Totalspace（kbytes）:
262120
Usedspace（kbytes）:
2916
Availablespace（kbytes）:
259204
ID:
997200134
Device/FileName:
+DATA2
Device/Fileintegritychecksucceeded
Device/Filenotconfigured
Device/Filenotconfigured
Device/Filenotconfigured
Device/Filenotconfigured
Clusterregistryintegritychecksucceeded
查看Votedisk信息，迁移至新磁盘组
[grid@rac1~]$crsctlquerycssvotedisk
##STATEFileUniversalIdFileNameDiskgroup
------------------------------------------
1.ONLINEb0746a43f93c4ff2bf067cb97ffedf4e（/dev/asm-diskb）[SYSTEMDG]
2.ONLINEa54ec305b2c94febbf10c7426bad5ab8（/dev/asm-diskc）[SYSTEMDG]
3.ONLINE3b9ff9c1f7884f02bfedb22d5cdfc463（/dev/asm-diskd）[SYSTEMDG]
4.ONLINEa4c764cb429e4fcdbf4ac458b9f51803（/dev/asm-diske）[SYSTEMDG]
5.ONLINE23f5f064b0734f9bbf486a9d3a6df62f（/dev/asm-diskf）[SYSTEMDG]
Located5votingdisk（s）.
[grid@rac1~]$crsctlreplacevotedisk+DATA2
Successfuladditionofvotingdisk06d88831dc8b4fa0bf0213c802aeb8d8.
Successfuldeletionofvotingdiskb0746a43f93c4ff2bf067cb97ffedf4e.
Successfuldeletionofvotingdiska54ec305b2c94febbf10c7426bad5ab8.
Successfuldeletionofvotingdisk3b9ff9c1f7884f02bfedb22d5cdfc463.
Successfuldeletionofvotingdiska4c764cb429e4fcdbf4ac458b9f51803.
Successfuldeletionofvotingdisk23f5f064b0734f9bbf486a9d3a6df62f.
Successfullyreplacedvotingdiskgroupwith+DATA2.
CRS-4266:
Votingfile（s）successfullyreplaced
[grid@rac1~]$crsctlquerycssvotedisk
##STATEFileUniversalIdFileNameDiskgroup
------------------------------------------
1.ONLINE06d88831dc8b4fa0bf0213c802aeb8d8（/dev/asm-diskk）[DATA2]
Located1votingdisk（s）.
三、MovingserversideASMSPfiletonewASMdiskgroup
查看ASMSPFILE信息，迁移到新磁盘组
[grid@rac1~]$sqlplus/assysasm
SQL*Plus:
Release11.2.0.3.0ProductiononWedJun2210:
16:
532016
Copyright（c）1982,2011,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions
SQL>showparameterspfile
NAMETYPEVALUE
-----------------------------------------------------------------------------
spfilestring+SYSTEMDG/vmac-cluster/asmpara
meterfile/registry.253.8654292
27
验证spfile路径
ASMCMD>spget+SYSTEMDG/vmac-cluster/asmparameterfile/registry.253.865429227
+SYSTEMDG/vmac-cluster/asmparameterfile/registry.253.865429227
ASMCMD>spget
+SYSTEMDG/vmac-cluster/asmparameterfile/registry.253.865429227
SQL>createpfile='/tmp/asm_pfile.ora'fromspfile
SQL>createspfile='+DATA2'frompfile='/tmp/asm_pfile.ora';
Filecreated.
NewSPfilelocationwillbeloggedontheASMalertlog
NOTE:
updatedgpnpprofileASMSPFILEto+DATA2/dbatst-scan/asmparameterfile/registry.253.828801675
[grid@rac1trace]$tailalert_+ASM1.log
WedJun2210:
41:
552016
NOTE:
updatedgpnpprofileASMdiskstring:
/dev/asm*
NOTE:
updatedgpnpprofileASMdiskstring:
/dev/asm*
NOTE:
updatedgpnpprofileASMSPFILEto+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
[grid@rac1~]$asmcmd
ASMCMD>spget
+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
ASMCMD>spget+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
ASMCMD>
四、MovingdatabaserelatedfilestonewASMdiskgroup
控制文件迁移
SQL>showparametercontrol
NAMETYPEVALUE
-----------------------------------------------------------------------------
control_file_record_keep_timeinteger7
control_filesstring+DATA/dcdb/controlfile/current
.256.865439483,+FRA/dcdb/cont
rolfile/current.256.865439483
SQL>createpfile='/home/oracle/pfile.ora'fromspfile;
Filecreated.
SQL>altersystemsetcontrol_files='+DATA2','+FRA2'scope=spfilesid='*';
Systemaltered.
[oracle@rac1~]$srvctlstopdatabase-ddcdb
启动实例1到nomount状态
[oracle@rac1~]$srvctlstartinstance-ddcdb-idcdb1-onomount
[oracle@rac1~]$srvctlstatusinstance-ddcdb-idcdb1
Instancedcdb1isrunningonnoderac1
[oracle@rac1~]$rmantarget/
RecoveryManager:
Release11.2.0.3.0-ProductiononWedJun2210:
56:
082016
Copyright（c）1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.
connectedtotargetdatabase:
DCDB（notmounted）
RMAN>restorecontrolfilefrom'+DATA/dcdb/controlfile/current.256.865439483'
2>;
Startingrestoreat22-JUN-16
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
SID=37instance=dcdb1devicetype=DISK
channelORA_DISK_1:
copiedcontrolfilecopy
outputfilename=+DATA2/dcdb/controlfile/current.256.915188239
outputfilename=+FRA2/dcdb/controlfile/current.256.915188241
Finishedrestoreat22-JUN-16
[oracle@rac1~]$sqlplus/assysdba
SQL*Plus:
Release11.2.0.3.0ProductiononWedJun2210:
58:
242016
Copyright（c）1982,2011,Oracle.Allrightsreserved.
Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.2.0.3.0-64bitProduction
WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,
DataMiningandRealApplicationTestingoptions
SQL>alterdatabasemount
2;
Databasealtered.
SQL>alterdatabaseopen;
Databasealtered.
SQL>showparametercontrol
NAMETYPEVALUE
-----------------------------------------------------------------------------
control_file_record_keep_timeinteger7
control_filesstring+DATA2/dcdb/controlfile/curren
t.256.915188239,+FRA2/dcdb/co
ntrolfile/current.256.91518824
1
五.MovingSPfileton
升级会员 