ASM下如何迁移spfile
这篇文章主要讲解了“ASM下如何迁移spfile”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“ASM下如何迁移spfile”吧!
HowtomoveASMspfiletoadifferentdiskgroup[ID1082943.1]适用于11R2有两种方法:采用createpfile/spflie通过中间文件迁移;适用asmcmd自带的spcopy命令;第一种方法比较简单,步骤如下createpfile='/tmp/pfile+ASM.ora'fromspfile;createspfile='+PLAY'frompfile='/tmp/pfile+ASM.ora';crsctlstophascrsctlstarthas--重启验证下面介绍一下spcopy命令由于GPnPprofile记录有spfile路径信息,因此需添加-u选项自动更新1.Copyspfilewith-uoption-toupdateGPnPprofileinRACenvironment$asmcmdspget+DATA/asm/asmparameterfile/registry.253.722601213$asmcmdlsdgStateTypeRebalSectorBlockAUTotal_MBFree_MBReq_mir_free_MBUsable_file_MBOffline_disksVoting_filesNameMOUNTEDEXTERNN51240961048576146589814098140NDATA/MOUNTEDEXTERNN5124096104857697728507085070NPLAY/MOUNTEDEXTERNN5124096104857697729212092120NRECO/$asmcmdspcopy-u+DATA/asm/asmparameterfile/registry.253.722601213+PLAY/spfileASM.ora2.RestarttheHAstacktoverifythatASMstartsupfinewithcopiedspfile$crsctlstophasCRS-2791:StartingshutdownofOracleHighAvailabilityServices-managedresourceson'<server>'...CRS-4133:OracleHighAvailabilityServiceshasbeenstopped.$crsctlstarthasCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.$asmcmdspget+PLAY/spfileASM.ora3.Removetheoriginalspfile$asmcmdls-l+DATA/asm/asmparameterfileTypeRedundStripedTimeSysNameASMPARAMETERFILEUNPROTCOARSEJUN2510:00:00YREGISTRY.253.722601213$asmcmdrm+DATA/asm/asmparameterfile/registry.253.722601213NOTE:ThediskgroupthatholdsASMspfilehastohaveCOMPATIBLE.ASMvalueof11.2orhigher.
感谢各位的阅读,以上就是“ASM下如何迁移spfile”的内容了,经过本文的学习后,相信大家对ASM下如何迁移spfile这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是亿速云,小编将为大家推送更多相关知识点的文章,欢迎关注!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。