签到成功

知道了

CNDBA社区CNDBA社区

How To Rename A Diskgroup On ASM 11gR2

2016-11-25 15:50 1414 0 原创 Oracle 11g
作者: dave

 http://www.cndba.cn/Dave/article/797

       The present document provides a clear example about how to rename an ASM diskgroup on release 11gR2.

 

Solution

http://www.cndba.cn/Dave/article/797

 http://www.cndba.cn/Dave/article/797

1)  First of all, the desired diskgroup needs to be dismounted (from each node if this is a RAC configuration):

# asmcmd umount DATA



2) Verify that the desired diskgroup was dismounted:

http://www.cndba.cn/Dave/article/797

# 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 32756 31828 244 15792 0 N DATA_OCR/

MOUNTED EXTERN N 512 4096 1048576 16378 10134 0 10134 0 N LOBDATA/


3) Then execute the rename statement:

# renamedg phase=both dgname=DATA newdgname=DG_PROD_DATA verbose=true

Parsing parameters..

Parameters in effect:

Old DG name : DATA

New DG name : DG_PROD_DATA

Phases :

Phase 1

Phase 2

Discovery str : (null)

Clean : TRUE

Raw only : TRUE

renamedg operation: phase=both dgname=DATA newdgname=DG_PROD_DATA verbose=true

Executing phase 1

Discovering the group

Performing discovery with string:

Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:DATA1 with disk number:0 and timestamp (32925601 -972709888)

Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:DATA2 with disk number:1 and timestamp (32925601 -972709888)

Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:DATA3 with disk number:2 and timestamp (32925601 -972709888)

Checking for hearbeat...

Re-discovering the group

Performing discovery with string:

Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:DATA1 with disk number:0 and timestamp (32925601 -972709888)

Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:DATA2 with disk number:1 and timestamp (32925601 -972709888)

Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:DATA3 with disk number:2 and timestamp (32925601 -972709888)

Checking if the diskgroup is mounted

Checking disk number:0

Checking disk number:1

Checking disk number:2

Checking if diskgroup is used by CSS

Generating configuration file..

Completed phase 1

Executing phase 2

Looking for ORCL:DATA1

Modifying the header

Looking for ORCL:DATA2

Modifying the header

Looking for ORCL:DATA3

Modifying the header

Completed phase 2

Terminating kgfd context 0x2af21517e0a0


4) Finally, mount the renamed diskgroup and validate that it was mounted (on each node if this is a RAC configuration):

 

http://www.cndba.cn/Dave/article/797

# asmcmd mount DG_PROD_DATA

 

# 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 32756 31828 244 15792 0 N DATA_OCR/

MOUNTED EXTERN N 512 4096 1048576 24567 14267 0 14267 0 N DG_PROD_DATA/
MOUNTED EXTERN N 512 4096 1048576 16378 10134 0 10134 0 N LOBDATA/



<<< Note: renamedg tool cannot rename the associated ASM disk(s) name(s). >>>

 

 

 http://www.cndba.cn/Dave/article/797

 

http://www.cndba.cn/Dave/article/797

 

From Oracle

-------------------------------------------------------------------------------------------------------

Blog http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

http://www.cndba.cn/Dave/article/797

DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

聊天 群:40132017   聊天2群:69087192http://www.cndba.cn/Dave/article/797

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请http://www.cndba.cn/Dave/article/797

版权声明:本文为博主原创文章,未经博主允许不得转载。

oracle 11g

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
dave

dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 2261
    原创
  • 3
    翻译
  • 578
    转载
  • 191
    评论
  • 访问:7983315次
  • 积分:4346
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ