Oracle 11g R2 RAC with ASM存储迁移手记Word文档下载推荐.docx
《Oracle 11g R2 RAC with ASM存储迁移手记Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《Oracle 11g R2 RAC with ASM存储迁移手记Word文档下载推荐.docx(29页珍藏版)》请在冰豆网上搜索。
查看当前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
colnamefora10
setlinesize150
selectNAME,ALLOCATION_UNIT_SIZE,STATE,TOTAL_MB,FREE_MBUSABLE_FILE_MBfromgv$asm_diskgroup;
NAMEALLOCATION_UNIT_SIZESTATETOTAL_MBUSABLE_FILE_MB
-----------------------------------------------------------------
DATA1048576MOUNTED102406721
FRA1048576MOUNTED1331211081
SYSTEMDG1048576MOUNTED2560024344
6rowsselected.
selectfailgroup,namefromv$asm_diskwheregroup_number=(selectgroup_numberfromv$asm_diskgroupwherename='
DATA'
);
FAILGROUPNAME
----------------------------------------
DATA_0001DATA_0001
DATA_0000DATA_0000
利用asmca命令创建DISKGROUP
相关的sql语句
CREATEDISKGROUPDATA2EXTERNALREDUNDANCYDISK'
/dev/asm-diskk'
SIZE20480MATTRIBUTE'
compatible.asm'
='
11.2.0.0.
0'
'
au_size'
1M'
/*ASMCA*/
CREATEDISKGROUPFRA2EXTERNALREDUNDANCYDISK'
/dev/asm-diskl'
SIZE5120MATTRIBUTE'
11.2.0.0.0'
磁盘组状态
ora.DATA.dg
ONLINEONLINErac1
ONLINEONLINErac2
ora.DATA2.dg
ora.FRA.dg
ora.FRA2.dg
ora.LISTENER.lsnr
ONLINEOFFLINErac2
ora.SYSTEMDG.dg
ora.asm
ONLINEONLINErac1Started
ONLINEONLINErac2Started
[grid@rac1~]$sqlplus/assysdba
Release11.2.0.3.0ProductiononWedJun2210:
02:
372016
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
Clusterregistryintegritychecksucceeded
Logicalcorruptioncheckbypassedduetonon-privilegeduser
添加ocr磁盘组
[root@rac1bin]#./ocrconfig-add+DATA2
[root@rac1bin]#./ocrcheck
+DATA2
Logicalcorruptionchecksucceeded
删除OCR旧磁盘组
[root@rac1bin]#./ocrconfig-delete+SYSTEMDG
查看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
1.ONLINE06d88831dc8b4fa0bf0213c802aeb8d8(/dev/asm-diskk)[DATA2]
Located1votingdisk(s).
三、MovingserversideASMSPfiletonewASMdiskgroup
查看ASMSPFILE信息,迁移到新磁盘组
[grid@rac1~]$sqlplus/assysasm
16:
532016
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
spget
createpfile='
/tmp/asm_pfile.ora'
fromspfile
createspfile='
+DATA2'
frompfile='
;
Filecreated.
NewSPfilelocationwillbeloggedontheASMalertlog
NOTE:
updatedgpnpprofileASMSPFILEto+DATA2/dbatst-scan/asmparameterfile/registry.253.828801675
[grid@rac1trace]$tailalert_+ASM1.log
WedJun2210:
41:
552016
updatedgpnpprofileASMdiskstring:
/dev/asm*
updatedgpnpprofileASMSPFILEto+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
[grid@rac1~]$asmcmd
+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
spget+DATA2/vmac-cluster/asmparameterfile/registry.253.915187315
四、MovingdatabaserelatedfilestonewASMdiskgroup
控制文件迁移
showparametercontrol
control_file_record_keep_timeinteger7
control_filesstring+DATA/dcdb/controlfile/current
.256.865439483,+FRA/dcdb/cont
rolfile/current.256.865439483
/home/oracle/pfile.ora'
fromspfile;
altersystemsetcontrol_files='
+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
copiedcontrolfilecopy
outputfilename=+DATA2/dcdb/controlfile/current.256.915188239
outputfilename=+FRA2/dcdb/controlfile/current.256.915188241
Finishedrestoreat22-JUN-16
[oracle@rac1~]$sqlplus/assysdba
58:
242016
WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,
DataMiningandRealApplicationTestingoptions
alterdatabasemount
2;
Databasealtered.
alterdatabaseopen;
control_filesstring+DATA2/dcdb/controlfile/curren
t.256.915188239,+FRA2/dcdb/co
ntrolfile/current.256.91518824
1
五.MovingSPfileton