ASMDG磁盘组重命名

预备：验证从库db_create_dest参数

1、验证ASMDG信息（双节点）

su - grid
asmcmd lsdg

2、umount DG（双节点）

asmcmd umount MDM
asmcmd lsdg

3、查看asm_diskstring参数

echo $ORACLE_SID
sqlplus / as sysasm
show parameter asm_diskstring

4、预检是否可以执行成功

renamedg phase=both dgname=MDM newdgname=EBSDATADG2 verbose=true config=/home/grid/disk.conf check=true

5、重名DG的名称

renamedg phase=both dgname=MDM newdgname=EBSDATADG2 verbose=true config=/home/grid/disk.conf

6、修改DG下disk的名称（可以跳过） 

asmcmd mount --restrict EBSDATADG2

sqlplus / as sysasm
set linesize 200
col NAME format a20
col PATH format a20
col FAILGROUP format a20
select ads.NAME "DISK_NAME",adgs.NAME " DG_NAME",ads.FAILGROUP,ads.PATH from v$asm_disk_stat ads, v$asm_diskgroup_stat adgs 
where ads.GROUP_NUMBER = adgs.GROUP_NUMBER;

alter diskgroup EBSDATADG2 rename disks all;

select ads.NAME "DISK_NAME",adgs.NAME " DG_NAME",ads.FAILGROUP,ads.PATH
from v$asm_disk_stat ads, v$asm_diskgroup_stat adgs
where ads.GROUP_NUMBER = adgs.GROUP_NUMBER;


asmcmd umount EBSDATADG2

 

 

7. 在每个节点，将DG mount起来

su - grid
asmcmd mount EBSDATADG2
asmcmd lsdg

8、移除旧DG

su - grid
crsctl status res -t
srvctl remove diskgroup -diskgroup MDM
crsctl status res -t

9、添加数据文件
表空间使用率

set linesize 500 pagesize 500
col tablespace_name format a20
col Sum_space(M) format a20
col Used_space(M) format a20
col Free_space(M) format a20
select a.tablespace_name,
       totalspace || ' M' "Sum_space(M)",
       round((totalspace - nvl(freespace, 0)), 3) || ' M' "Used_space(M)",
       round(((totalspace - nvl(freespace, 0)) / totalspace), 3) * 100 "Used_Rate(%)",
       nvl(freespace, 0) || ' M' "Free_space(M)"
  from (select tablespace_name, sum(bytes) / 1048576 totalspace
          from dba_data_files
         group by tablespace_name) a,
       (select tablespace_name, sum(Bytes) / 1048576 freespace
          from dba_free_space
         group by tablespace_name) b
 where a.tablespace_name = b.tablespace_name(+)
union
select a.tablespace_name,
       space || ' M' "Sum_space(M)",
       used_space || ' M' "Used_space(M)",
       round(nvl(used_space, 0) / space * 100, 2) "Used_Rate(%)",
       nvl(free_space, 0) || ' M' "Free_space(M)"
  from (select tablespace_name,
               round(sum(bytes) / (1024 * 1024), 2) space,
               sum(blocks) blocks
          from dba_temp_files
         group by tablespace_name) a,
       (select tablespace_name,
               round(sum(bytes_used) / (1024 * 1024), 2) used_space,
               round(sum(bytes_free) / (1024 * 1024), 2) free_space
          from v$temp_space_header
         group by tablespace_name) b
 where a.tablespace_name = b.tablespace_name(+);

9.1、添加数据文件
9.2、关闭自动扩展
 
 
--数据文件

set linesize 200 pagesize 300
col tablespace_name format a20
col datafile_name format a100
col AUTOEXTENSIBLE format a10
select tps.TS#,tps.name tablespace_name,df.name datafile_name,ddf.AUTOEXTENSIBLE,df.BYTES/1024/1024/1024 || ' GB' as "datafile_size" from 
V$TABLESPACE tps,v$datafile df, DBA_DATA_FILES ddf where df.TS#=tps.TS# and ddf.file_id=df.file#;

--临时文件

set linesize 200
col tablespace_name format a20
col file_name format a50
col autoextensible format a5
select tablespace_name,file_name,bytes/1024/1024 "file_size(M)",autoextensible from dba_temp_files;