共计 5997 个字符，预计需要花费 15 分钟才能阅读完成。
本篇文章给大家分享的是有关 ASM 中怎么重命名 kgroup，丸趣 TV 小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着丸趣 TV 小编一起来看看吧。
ASM 管理 – 如何重命名 diskgroup
ASM 11.2.0.1 版本开始增加了 diskgroup 重命名的新功能，通过 renamedg 命令重命名已经创建的 diskgroup，重命名前需要先 dismount diskgroup。
如果重命名的 diskgroup 已经用于存储数据库的数据文件，那么需要手动同步数据文件的位置。
– 检查 ASM diskgroup 当前名字为 DGASMDB
$ su – grid
$ sqlplus / as sysasm
SQL select GROUP_NUMBER,name,state,type, offline_disks, ALLOCATION_UNIT_SIZE,BLOCK_SIZE,TOTAL_MB,FREE_MB from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TYPE OFFLINE_DISKS ALLOCATION_UNIT_SIZE BLOCK_SIZE TOTAL_MB FREE_MB
———— ———- ——– —— ————- ——————– ———- ———- ———-
1 DGASMDB MOUNTED EXTERN 0 1048576 4096 3992 1879
– 检查数据库当前信息(spfile/controlfile/datafile/redo)
su – oracle
$ sqlplus / as sysdba
SQL show parameter spfile;
NAME TYPE VALUE
———————————— ———– ——————————
spfile string +DGASMDB/asmdb/spfileasmdb.ora
SQL show parameter control
NAME TYPE VALUE
———————————— ———– ——————————
control_files string +DGASMDB/asmdb/controlfile/current.256.856653049
SQL select name from v$datafile;
NAME
——————————————————————————–
+DGASMDB/asmdb/datafile/system.260.856653053
+DGASMDB/asmdb/datafile/sysaux.261.856653059
+DGASMDB/asmdb/datafile/undotbs1.262.856653061
+DGASMDB/asmdb/datafile/users.264.856653075
+DGASMDB/asmdb/datafile/asm_test.dbf
SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
–dismount diskgroup dgasmdb
$ su – grid
$ asmcmd umount dgasmdb
– 重命令 diskgroup，新的 diskgroup 名为 dgasmdb_new
$ renamedg phase=both dgname=dgasmdb newdgname=dgasmdb_new verbose=true
Parsing parameters..
Parameters in effect:
Old DG name : DGASMDB
New DG name : DGASMDB_NEW
Phases :
Phase 1
Phase 2
Discovery str : (null)
Clean : TRUE
Raw only : TRUE
renamedg operation: phase=both dgname=dgasmdb newdgname=dgasmdb_new 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:ASMDISK4G1 with disk number:0 and timestamp (33006423 142494720)
Checking for hearbeat…
Re-discovering the group
Performing discovery with string:
Identified disk ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so:ORCL:ASMDISK4G1 with disk number:0 and timestamp (33006423 142494720)
Checking if the diskgroup is mounted or used by CSS
Checking disk number:0
Generating configuration file..
Completed phase 1
Executing phase 2
Looking for ORCL:ASMDISK4G1
Modifying the header
Completed phase 2
Terminating kgfd context 0x7fa6c2bee0a0
–mount 新的 diksgroup dgasmdb_new
$ asmcmd mount dgasmdb_new
– 查看新的 diskgroup 信息
SQL select GROUP_NUMBER,name,state,type, offline_disks, ALLOCATION_UNIT_SIZE,BLOCK_SIZE,TOTAL_MB,FREE_MB from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TYPE OFFLINE_DISKS ALLOCATION_UNIT_SIZE BLOCK_SIZE TOTAL_MB FREE_MB
———— ———– ——– —— ————- ——————– ———- ———- ———-
1 DGASMDB_NEW MOUNTED EXTERN 0 1048576 4096 3992 1879
– 修改 DB 初始化参数 (/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initasmdb.ora) 配置信息
原来：SPFILE= +DGASMDB/asmdb/spfileasmdb.ora
修改后：SPFILE= +DGASMDB_NEW/asmdb/spfileasmdb.ora
– 启动数据库 nomount
su – oracle
sqlplus / as sysdba
startup nomount;
– 修改 control_files 参数：
SQL alter system set control_files= +DGASMDB_NEW/asmdb/controlfile/current.256.856653049 scope=spfile;
SQL shutdown immediate;
SQL startup mount;
SQL show parameter control_files
NAME TYPE VALUE
———————————— ———– ——————————
control_files string +DGASMDB_NEW/asmdb/controlfile
/current.256.856653049
– 确认当前记录的 datafile 还是位于原来 diskgroup DGASMDB
SQL select FILE#,name from v$datafile;
FILE# NAME
———- —————————————————————————————————-
1 +DGASMDB/asmdb/datafile/system.260.856653053
2 +DGASMDB/asmdb/datafile/sysaux.261.856653059
3 +DGASMDB/asmdb/datafile/undotbs1.262.856653061
4 +DGASMDB/asmdb/datafile/users.264.856653075
5 +DGASMDB/asmdb/datafile/asm_test.dbf
SQL select file#, name from v$tempfile;
FILE# NAME
———- ——————————————————————————–
1 +DGASMDB/asmdb/tempfile/temp.263.856653061
– 修改 datafile/tempfile 位置:
SQL conn / as sysdba
SQL ALTER DATABASE RENAME FILE +DGASMDB/asmdb/datafile/system.260.856653053 TO +DGASMDB_NEW/asmdb/datafile/system.260.856653053
SQL ALTER DATABASE RENAME FILE +DGASMDB/asmdb/datafile/sysaux.261.856653059 TO +DGASMDB_NEW/asmdb/datafile/sysaux.261.856653059
SQL ALTER DATABASE RENAME FILE +DGASMDB/asmdb/datafile/undotbs1.262.856653061 TO +DGASMDB_NEW/asmdb/datafile/undotbs1.262.856653061
SQL ALTER DATABASE RENAME FILE +DGASMDB/asmdb/datafile/users.264.856653075 TO +DGASMDB_NEW/asmdb/datafile/users.264.856653075
SQL ALTER DATABASE RENAME FILE +DGASMDB/asmdb/datafile/asm_test.dbf TO +DGASMDB_NEW/asmdb/datafile/asm_test.dbf
SQL ALTER DATABASE RENAME FILE +DGASMDB/asmdb/tempfile/temp.263.856653061 TO +DGASMDB_NEW/asmdb/tempfile/temp.263.856653061
– 修改后确认：
SQL select FILE#,name from v$datafile;
FILE# NAME
———- —————————————————————————————————-
1 +DGASMDB_NEW/asmdb/datafile/system.260.856653053
2 +DGASMDB_NEW/asmdb/datafile/sysaux.261.856653059
3 +DGASMDB_NEW/asmdb/datafile/undotbs1.262.856653061
4 +DGASMDB_NEW/asmdb/datafile/users.264.856653075
5 +DGASMDB_NEW/asmdb/datafile/asm_test.dbf
– 修改 redo log 位置
alter database rename file +DGASMDB/asmdb/onlinelog/group_1.257.856653049 to +DGASMDB_NEW/asmdb/onlinelog/group_1.257.856653049
alter database rename file +DGASMDB/asmdb/onlinelog/group_2.258.856653051 to +DGASMDB_NEW/asmdb/onlinelog/group_2.258.856653051
alter database rename file +DGASMDB/asmdb/onlinelog/group_3.259.856653051 to +DGASMDB_NEW/asmdb/onlinelog/group_3.259.856653051
select * from v$logfile;
– 启动数据库
SQL alter database open;
以上就是 ASM 中怎么重命名 kgroup，丸趣 TV 小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注丸趣 TV 行业资讯频道。
