Oracle 11g R2 RAC with ASM存储迁移手记.docx
- 文档编号:4770915
- 上传时间:2022-12-08
- 格式:DOCX
- 页数:29
- 大小:168.45KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle 11g R2 RAC with ASM存储迁移手记 11 ASM 存储 迁移 手记