利用Oracle Rac 11gR2 新特性renamedg来更改diskgroup name
来源:互联网 发布:网络都有哪些 编辑:程序博客网 时间:2024/06/09 15:32
交代环境:
AIX7.1 + 双节点Oracle Rac 11.2.0.3
由于此套Rac并非自己部门安装,是开发部安装,现交由运维部分来管理,客户需要要将asm diskgroup name 安装部门规范来命令。遂需要将oasmdgdata1更改为datadg。
幸好Oracle的版本是11gR2,在11gR2中,Oracle有一项新特性,可以直接使用renamedg命令更改diskgroup的名称。
下面是具体的操作步骤。
grid@sundb01:/home/grid>asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 358400 358192 0 179096 0 N OASMDGDATA01/
MOUNTED NORMAL N 512 4096 1048576 15360 14434 5120 4657 0 Y OCRDG/
ASMCMD> umount oasmdgdata01
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 15360 14434 5120 4657 0 Y OCRDG/
grid@sundb01:/home/grid>renamedg -help
NOTE: No asm libraries found in the system
Parsing parameters..
phase Phase to execute,
(phase=ONE|TWO|BOTH), default BOTH
dgname Diskgroup to be renamed
newdgname New name for the diskgroup
config intermediate config file
check just check-do not perform actual operation,
(check=TRUE/FALSE), default FALSE
confirm confirm before committing changes to disks,
(confirm=TRUE/FALSE), default FALSE
clean ignore errors,
(clean=TRUE/FALSE), default TRUE
asm_diskstring ASM Diskstring (asm_diskstring='discoverystring',
'discoverystring1' ...)
verbose verbose execution,
(verbose=TRUE|FALSE), default FALSE
keep_voting_files Voting file attribute,
(keep_voting_files=TRUE|FALSE), default FALSE
利用renamedg来更改diskgroup的名称:
grid@sundb01:/home/grid>renamedg phase=both dgname=oasmdgdata01 newdgname=datadg verbose=true
NOTE: No asm libraries found in the system
Parsing parameters..
Parameters in effect:
Old DG name : OASMDGDATA01
New DG name : DATADG
Phases :
Phase 1
Phase 2
Discovery str :
Clean : TRUE
Raw only : TRUE
renamedg operation: phase=both dgname=oasmdgdata01 newdgname=datadg verbose=true
Executing phase 1
Discovering the group
Performing discovery with string:
Identified disk UFS:/dev/rhdisk2 with disk number:1 and timestamp (33002374 -296274944)
Identified disk UFS:/dev/rhdisk1 with disk number:0 and timestamp (33002374 -296274944)
Checking for hearbeat...
Re-discovering the group
Performing discovery with string:
Identified disk UFS:/dev/rhdisk2 with disk number:1 and timestamp (33002374 -296274944)
Identified disk UFS:/dev/rhdisk1 with disk number:0 and timestamp (33002374 -296274944)
Checking if the diskgroup is mounted or used by CSS
Checking disk number:1
Checking disk number:0
Generating configuration file..
Completed phase 1
Executing phase 2
Looking for /dev/rhdisk2
Modifying the header
Looking for /dev/rhdisk1
Modifying the header
Completed phase 2
Terminating kgfd context 110285ba0
grid@sundb01:/home/grid>
grid@sundb01:/home/grid>sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 10 12:33:31 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATADG DISMOUNTED
OCRDG MOUNTED
SQL> alter diskgroup datadg mount;
Diskgroup altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATADG MOUNTED
OCRDG MOUNTED
grid@sundb01:/home/grid>asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 358400 358192 0 179096 0 N DATADG/
MOUNTED NORMAL N 512 4096 1048576 15360 14434 5120 4657 0 Y OCRDG/
ASMCMD>
ASMCMD> exit
grid@sundb01:/home/grid>sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 10 12:39:41 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select name,path from v$asm_disk;
NAME PATH
------------------------------ ----------------------------------------
OASMDGDATA01_0000 /dev/rhdisk1 -----从此处发现,其实即使更改了diskgroup的name,disk name也没有改变。
OASMDGDATA01_0001 /dev/rhdisk2 -----通过kfed查看磁盘头信息仍然会发现diskgroup name 还是之前的那个名称。
OCRDG_0000 /dev/rhdisk3
OCRDG_0001 /dev/rhdisk4
OCRDG_0002 /dev/rhdisk5
此处还需要将crs中的OASMDGDATA01信息给删除:
grid@sundb01:/home/grid>crs_stat
NAME=ora.DATADG.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on sundb01
NAME=ora.OASMDGDATA01.dg
TYPE=ora.diskgroup.type
TARGET=OFFLINE
STATE=OFFLINE
grid@sundb01:/home/grid>crsctl delete resource ora.OASMDGDATA01.dg
grid@sundb01:/home/grid>crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATADG.dg ora....up.type ONLINE ONLINE sundb01
ora....ER.lsnr ora....er.type ONLINE ONLINE sundb01
ora....R1.lsnr ora....er.type ONLINE ONLINE sundb01
ora....N1.lsnr ora....er.type ONLINE ONLINE sundb01
ora.OCRDG.dg ora....up.type ONLINE ONLINE sundb01
ora.asm ora.asm.type ONLINE ONLINE sundb01
ora.cvu ora.cvu.type ONLINE ONLINE sundb01
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE sundb01
ora....01.lsnr application ONLINE ONLINE sundb01
ora....01.lsnr application ONLINE ONLINE sundb01
ora....b01.gsd application OFFLINE OFFLINE
ora....b01.ons application ONLINE ONLINE sundb01
ora....b01.vip ora....t1.type ONLINE ONLINE sundb01
ora....SM2.asm application ONLINE ONLINE sundb02
ora....02.lsnr application ONLINE ONLINE sundb02
ora....02.lsnr application ONLINE ONLINE sundb02
ora....b02.gsd application OFFLINE OFFLINE
ora....b02.ons application ONLINE ONLINE sundb02
ora....b02.vip ora....t1.type ONLINE ONLINE sundb02
ora....network ora....rk.type ONLINE ONLINE sundb01
ora.oc4j ora.oc4j.type ONLINE ONLINE sundb02
ora.ons ora.ons.type ONLINE ONLINE sundb01
ora....ry.acfs ora....fs.type ONLINE ONLINE sundb01
ora.scan1.vip ora....ip.type ONLINE ONLINE sundb01
0 0
- 利用Oracle Rac 11gR2 新特性renamedg来更改diskgroup name
- Oracle 11gR2 RAC 新特性说明
- Oracle 11gR2 RAC 新特性说明
- Oracle 11gR2 RAC 新特性说明
- Oracle 11gR2 RAC 新特性说明
- Oracle 11gR2 RAC Votedisk and OCR Diskgroup Recovery
- ORACLE 11GR2 RAC new features 新特性。
- Oracle 11gR2 RAC 新特性说明 收藏
- Oracle 11gR2 新特性 概述
- Oracle 11gR2 RAC alert_+ASM1.log出现WARNING: failed to online diskgroup resource ora.CRS.dg (unable to
- 11gR2 RAC 新特性-SCAN-GNS-RAC One Node等
- Oracle Study之--Oracle 11gR2访问ASM diskgroup错误
- oracle 11gR2 RAC 安装
- 卸载Oracle 11gR2 RAC
- Oracle 11gR2 Relink 脚本 新特性 说明
- 11gR2 新特性:Oracle Cluster Health Monitor(CHM)简介
- 【翻译自mos文章】Oracle 11gR2 relink 新特性
- 11gR2 新特性:Oracle Cluster Health Monitor(CHM)简介
- 插入排序
- Hdu 4081 Qin Shi Huang's National Road System(最小生成树)
- UVA - 1354(指针结点的联合方法 || 高效算法复杂度未算出)
- 对openvSwitch中不同类型端口的理解
- 在connect中编写自己的路由器及最佳实践
- 利用Oracle Rac 11gR2 新特性renamedg来更改diskgroup name
- python 判断带路径的文件是否存在,否则创建
- 并发编程之屏障CyclicBarrier
- 用jquery给Struts2的<s:radio />标签添加change事件
- 最大子序列、最长递增子序列、最长公共子串、最长公共子序列、字符串编辑距离
- 基础练习5_查找整数
- QQ产品界面变更之路
- SDN的初步学习总结
- ServletContextListener