asm下添加和删除磁盘组

  此次要删除arch磁盘组,需要先修改归档位置:

 alter system set log_archive_dest_1=‘location=+data/Elandg/archive‘ scope=both sid=‘*‘;

  查看asm磁盘包含关系:

SQL> select name,path from v$asm_disk;

NAME			       PATH
------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OCR_0002		       /dev/sdk
OCR_0001		       /dev/sdj
OCR_0000		       /dev/sdi
ARCH_0000		       /dev/sdh
DATA_0000		       /dev/sdg

  查看asm磁盘组状态:

SQL>  select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME							     STATE		      TOTAL_MB	  FREE_MB
------------------------------------------------------------ ---------------------- ---------- ----------
ARCH							     MOUNTED			 48800	    47174
DATA							     MOUNTED			 48800	    40437
OCR							     MOUNTED			  5760	     4720

  强制卸载asm磁盘组(两个节点都做):

删除磁盘组:

SQL> DROP DISKGROUP ARCH FORCE INCLUDING CONTENTS; 

Diskgroup dropped.


SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME        STATE		TOTAL_MB    FREE_MB
---------------------- ---------- ----------
DATA    MOUNTED 		    48800      40458

OCR    MOUNTED 		     5760	4720

  添加磁盘组,并修改扇区大小:(如无扇区大小需求,可默认):

============================================
oracle示例:
CREATE DISKGROUP data NORMAL REDUNDANCY
  FAILGROUP controller1 DISK
    ‘/devices/diska1‘ NAME diska1,
    ‘/devices/diska2‘ NAME diska2,
    ‘/devices/diska3‘ NAME diska3,
    ‘/devices/diska4‘ NAME diska4
  FAILGROUP controller2 DISK
    ‘/devices/diskb1‘ NAME diskb1,
    ‘/devices/diskb2‘ NAME diskb2,
    ‘/devices/diskb3‘ NAME diskb3,
    ‘/devices/diskb4‘ NAME diskb4
  ATTRIBUTE ‘au_size‘=‘4M‘,
    ‘compatible.asm‘ = ‘11.2‘, 
    ‘compatible.rdbms‘ = ‘11.2‘,
    ‘compatible.advm‘ = ‘11.2‘;

==========================================
oracle示例:

CREATE DISKGROUP mgmt_dg NORMAL REDUNDANCY
   FAILGROUP fg1 DISK ‘/devices/diskg1‘
   FAILGROUP fg2 DISK ‘/devices/diskg2‘
   QUORUM FAILGROUP fg3 DISK ‘/devices/diskg3‘
   ATTRIBUTE ‘compatible.asm‘ = ‘12.2.0.0.0‘;
=============================================

本环境使用:
CREATE DISKGROUP arch EXTENDED REDUNDANCY DISK ‘/dev/sdh‘ ATTRIBUTE ‘compatible.asm‘ = ‘11.2‘, ‘compatible.rdbms‘ = ‘11.2‘, ‘sector_size‘=‘4096‘;


SQL> CREATE DISKGROUP arch external REDUNDANCY DISK ‘/dev/sdh‘ ATTRIBUTE ‘compatible.asm‘ = ‘11.2‘, ‘compatible.rdbms‘ = ‘11.2‘, ‘sector_size‘=‘4096‘;

Diskgroup created.

SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME
------------------------------------------------------------
STATE TOTAL_MB FREE_MB
---------------------- ---------- ----------
ARCH
MOUNTED 48800 48748

DATA
MOUNTED 48800 40458

OCR
MOUNTED 5760 4720

 

第二个节点需要将arch磁盘组mount一下:

SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME STATE TOTAL_MB FREE_MB
---------------------- ---------- ----------
ARCH  DISMOUNTED 0 0

DATA  MOUNTED 48800 40458

OCR  MOUNTED 5760 4720


SQL>
SQL> alter diskgroup ARCH mount;

Diskgroup altered.

SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME STATE TOTAL_MB FREE_MB

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

ARCH  MOUNTED 48800 48705

DATA  MOUNTED 48800 40458

OCR  MOUNTED 5760 4720

  

添加完成后查询:

SQL> SELECT SUBSTR(dg.name,1,16) AS diskgroup, SUBSTR(d.name,1,16) AS asmdisk,
     d.mount_status, d.state, SUBSTR(d.failgroup,1,16) AS failgroup 
     FROM V$ASM_DISKGROUP dg, V$ASM_DISK d WHERE dg.group_number = d.group_number; 

DISKGROUP			 ASMDISK			  MOUNT_S STATE    FAILGROUP
-------------------------------- -------------------------------- ------- -------- --------------------------------
OCR				 OCR_0002			  CACHED  NORMAL   OCR_0002
OCR				 OCR_0001			  CACHED  NORMAL   OCR_0001
OCR				 OCR_0000			  CACHED  NORMAL   OCR_0000
ARCH				 ARCH_0000			  CACHED  NORMAL   ARCH_0000
DATA				 DATA_0000			  CACHED  NORMAL   DATA_0000

  

 

asm下添加和删除磁盘组

上一篇:Winform中创建超链接,点击跳转网页


下一篇:CSS高级