ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称
ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称
联系：手机/微信(+86 13429648788) QQ(107644445)
标题：ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
今天看着我这个单节点的12C rac,突然觉得ocr所在的磁盘组叫做+DG_SYS有点不舒服，想改成+SYS_DG。处理方法是先把ocr/votedisk/asm spfile迁移到已经存在的asm中,然后修改磁盘组名称,最后迁移到新名称磁盘组中(本次处理流程+DG_SYS—>+DATA—>+SYS_DG)
当前运行情况
[grid@xifenfei ~]$ crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE xifenfei STABLEora.DATA.dg ONLINE ONLINE xifenfei STABLEora.LISTENER.lsnr ONLINE ONLINE xifenfei STABLEora.net1.network ONLINE ONLINE xifenfei STABLEora.ons ONLINE ONLINE xifenfei STABLEora.proxy_advm ONLINE OFFLINE xifenfei STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xifenfei STABLEora.MGMTLSNR 1 ONLINE ONLINE xifenfei 169.254.196.108 10.1 0.30.22,STABLEora.asm 1 ONLINE ONLINE xifenfei Started,STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLEora.cdb.db 1 ONLINE ONLINE xifenfei Open,STABLEora.cvu 1 ONLINE ONLINE xifenfei STABLEora.oc4j 1 ONLINE ONLINE xifenfei STABLEora.scan1.vip 1 ONLINE ONLINE xifenfei STABLEora.xifenfei.vip 1 ONLINE ONLINE xifenfei STABLE--------------------------------------------------------------------------------SQL> select * from v$version;BANNER CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0PL/SQL Release 12.1.0.1.0 - Production 0CORE 12.1.0.1.0 Production 0TNS for Linux: Version 12.1.0.1.0 - Production 0NLSRTL Version 12.1.0.1.0 - Production 0SQL> select name,state from v$asm_diskgroup;NAME STATE------------------------------ -----------DG_SYS MOUNTEDDATA MOUNTED[grid@xifenfei ~]$ crsctl query css votedisk## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ---------1. ONLINE 60a037da30714f6bbfe5d90206ff27a7 (/dev/sdc2) [DG_SYS]Located 1 voting disk(s).[grid@xifenfei ~]$ ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1380 Available space (kbytes) : 408188 ID : 2132096904 Device/File Name : +DG_SYS Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check bypassed due to non-privileged userSQL> show parameter spfile;NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DG_SYS/xff-cluster/ASMPARAMET ERFILE/registry.253.825640465 |
修改ocr路径
ocrconfig -add和ocrconfig -delete完成ocr更换磁盘组,该过程可以在线处理
[root@xifenfei ~]# ocrconfig -add +data--alert 日志2013-09-09 22:32:40.799: [crsd(5064)]CRS-1007:The OCR/OCR mirror location was replaced by +data.[root@xifenfei ~]# ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1380 Available space (kbytes) : 408188 ID : 2132096904 Device/File Name : +DG_SYS Device/File integrity check succeeded Device/File Name : +data Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded[root@xifenfei ~]# ocrconfig -delete +DG_SYS--alert 日志2013-09-09 22:35:53.585: [crsd(5064)]CRS-1010:The OCR mirror location +DG_SYS was removed.[root@xifenfei ~]# ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1380 Available space (kbytes) : 408188 ID : 2132096904 Device/File Name : +data Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded |
修改votedisk路径
通过crsctl replace votedisk命令修改
[root@xifenfei ~]# crsctl replace votedisk +DATASuccessful addition of voting disk 161ddea0a5fe4f28bfb67536e6105122.Successful deletion of voting disk 60a037da30714f6bbfe5d90206ff27a7.Successfully replaced voting disk group with +DATA.CRS-4266: Voting file(s) successfully replaced-alert日志2013-09-09 22:38:15.259: [cssd(4685)]CRS-1605:CSSD voting file is online: /dev/sdb; details in /u01/app/12.1/grid/product/log/xifenfei/cssd/ocssd.log.2013-09-09 22:38:15.259: [cssd(4685)]CRS-1626:A Configuration change request completed successfully2013-09-09 22:38:15.285: [cssd(4685)]CRS-1601:CSSD Reconfiguration complete. Active nodes are xifenfei .[root@xifenfei ~]# crsctl query css votedisk## STATE File Universal Id File Name Disk group-- ----- ----------------- --------- ---------1. ONLINE 161ddea0a5fe4f28bfb67536e6105122 (/dev/sdb) [DATA]Located 1 voting disk(s). |
修改asm spfile位置
[grid@xifenfei ~]$ gpnptool get -o-Success.…………<orcl:ASM-Profile id="asm" DiscoveryString="/dev/sd*" SPFile="+DG_SYS/xff-cluster/ASMPARAMETERFILE/registry.253.825640465" Mode="legacy"/>…………[grid@xifenfei ~]$ sqlplus / as sysasmSQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 9 22:42:05 2013Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> create pfile='/tmp/pfile.asm' from spfile;File created.SQL> create spfile='+DATA' FROM PFILE='/tmp/pfile.asm';File created.[grid@xifenfei ~]$ gpnptool get -o-Success.…………<orcl:ASM-Profile id="asm" DiscoveryString="/dev/sd*" SPFile="+DATA/xff-cluster/ASMPARAMETERFILE/registry.253.825720159" Mode="legacy"/>………… |
这里证明create asm spfile会自动修改spfile在gpnptool对应的profile里面的配置,无需人工干预
重启crs
为了使得asm使用新的磁盘组中的spfile文件
[root@xifenfei ~]# crsctl stop crs[root@xifenfei ~]# crsctl start crs |
验证+DG_SYS磁盘组未被使用
[grid@xifenfei ~]$ sqlplus / as sysasmSQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 9 22:59:49 2013Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter spfile;NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DATA/xff-cluster/ASMPARAMETER FILE/registry.253.825720159ASMCMD> lsofDB_Name Instance_Name Path +ASM +ASM1 +DATA.255.819326577 cdb cdb1 +DATA/CDB/CONTROLFILE/current.274.819356503 cdb cdb1 +DATA/CDB/DATAFILE/sysaux.278.819355829 cdb cdb1 +DATA/CDB/DATAFILE/system.269.819356101 cdb cdb1 +DATA/CDB/DATAFILE/undotbs1.276.819356317 cdb cdb1 +DATA/CDB/DATAFILE/users.279.819356309 cdb cdb1 +DATA/CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/pdbseed_temp01.dbf cdb cdb1 +DATA/CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/sysaux.272.819356709 cdb cdb1 +DATA/CDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/system.271.819356709 cdb cdb1 +DATA/CDB/ONLINELOG/group_1.277.822736453 cdb cdb1 +DATA/CDB/ONLINELOG/group_2.280.822736461 cdb cdb1 +DATA/CDB/ONLINELOG/group_3.275.822736397 cdb cdb1 +DATA/CDB/TEMPFILE/temp.273.819356649 |
dismount +DG_SYS磁盘组
ASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512 4096 1048576 20480 3369 0 3369 0 Y DATA/MOUNTED EXTERN N 512 4096 1048576 5451 5231 0 5231 0 N DG_SYS/ASMCMD> umount dg_sysASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512 4096 1048576 20480 3369 0 3369 0 Y DATA/ |
修改asm dg名称
修改磁盘组+DG_SYS为+SYS_DG
[grid@xifenfei ~]$ renamedg phase=both dgname=DG_SYS newdgname=SYS_DG verbose=trueParsing parameters..Parameters in effect: Old DG name : DG_SYS New DG name : SYS_DG Phases : Phase 1 Phase 2 Discovery str : (null) Clean : TRUE Raw only : TRUErenamedg operation: phase=both dgname=DG_SYS newdgname=SYS_DG verbose=trueExecuting phase 1Discovering the groupPerforming discovery with string:Identified disk UFS:/dev/sdc2 with disk number:0 and timestamp (32990496 1727895552)Checking for hearbeat...Re-discovering the groupPerforming discovery with string:Identified disk UFS:/dev/sdc2 with disk number:0 and timestamp (32990496 1727895552)Checking if the diskgroup is mounted or used by CSS Checking disk number:0Generating configuration file..Completed phase 1Executing phase 2Looking for /dev/sdc2Modifying the headerCompleted phase 2Terminating kgfd context 0x7fceeb02a0a0 |
mount +SYS_DG
SQL> select name,state from v$asm_diskgroup;NAME STATE------------------------------ -----------DATA MOUNTEDSYS_DG DISMOUNTEDSQL> alter diskgroup sys_dg mount;Diskgroup altered.SQL> select name,state from v$asm_diskgroup;NAME STATE------------------------------ -----------DATA MOUNTEDSYS_DG MOUNTED |
asm spfile/ocr/votedisk迁移从+DATA到+SYS_DG
SQL> create spfile='+SYS_DG' FROM pfile='/tmp/pfile.asm';File created.[root@xifenfei ~]# ocrconfig -add +SYS_DG[root@xifenfei ~]# ocrconfig -DELETE +DATA[root@xifenfei ~]# crsctl replace votedisk +SYS_DGSuccessful addition of voting disk 9694a31053ea4ff4bfb57891461a1296.Successful deletion of voting disk 161ddea0a5fe4f28bfb67536e6105122.Successfully replaced voting disk group with +SYS_DG.CRS-4266: Voting file(s) successfully replaced[root@xifenfei ~]# crsctl stop crs[root@xifenfei ~]# crsctl start crs |
删除ocr里面老磁盘组(+DG_SYS)信息
[root@xifenfei ~]# crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE xifenfei STABLEora.DATA.dg ONLINE ONLINE xifenfei STABLEora.DG_SYS.dg ONLINE OFFLINE xifenfei STABLEora.LISTENER.lsnr ONLINE ONLINE xifenfei STABLEora.SYS_DG.dg ONLINE ONLINE xifenfei STABLEora.net1.network ONLINE ONLINE xifenfei STABLEora.ons ONLINE ONLINE xifenfei STABLEora.proxy_advm ONLINE OFFLINE xifenfei STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xifenfei STABLEora.MGMTLSNR 1 ONLINE ONLINE xifenfei 169.254.196.108 10.1 0.30.22,STABLEora.asm 1 ONLINE ONLINE xifenfei Started,STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLEora.cdb.db 1 ONLINE ONLINE xifenfei Open,STABLEora.cvu 1 ONLINE ONLINE xifenfei STABLEora.oc4j 1 ONLINE ONLINE xifenfei STABLEora.scan1.vip 1 ONLINE ONLINE xifenfei STABLEora.xifenfei.vip 1 ONLINE ONLINE xifenfei STABLE--------------------------------------------------------------------------------[root@xifenfei ~]# srvctl remove diskgroup -diskgroup dg_sys[root@xifenfei ~]# crsctl status res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE xifenfei STABLEora.DATA.dg ONLINE ONLINE xifenfei STABLEora.LISTENER.lsnr ONLINE ONLINE xifenfei STABLEora.SYS_DG.dg ONLINE ONLINE xifenfei STABLEora.net1.network ONLINE ONLINE xifenfei STABLEora.ons ONLINE ONLINE xifenfei STABLEora.proxy_advm ONLINE OFFLINE xifenfei STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE xifenfei STABLEora.MGMTLSNR 1 ONLINE ONLINE xifenfei 169.254.196.108 10.1 0.30.22,STABLEora.asm 1 ONLINE ONLINE xifenfei Started,STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLEora.cdb.db 1 ONLINE ONLINE xifenfei Open,STABLEora.cvu 1 ONLINE ONLINE xifenfei STABLEora.oc4j 1 ONLINE ONLINE xifenfei STABLEora.scan1.vip 1 ONLINE ONLINE xifenfei STABLEora.xifenfei.vip 1 ONLINE ONLINE xifenfei STABLE-------------------------------------------------------------------------------- |
至此ocr/votedisk/asm spfile所在磁盘组修改名称完成,因为该库是一个单节点的rac,如果是两个或者更多节点的rac可以实现不停机的情况下进行(分步重启节点).该处理过程和11.2 rac完全相同,未有任何的改变
《ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称》有 1 条评论