oracle 11g asm 介绍,oracle 11g asm 基本操作

oracle 11g asm 基本操作

相关视图：

v$asm_diskgroup

v$asm_disk

v$asm_operation

----添加，删除磁盘

ALTER DISKGROUP diskgroup_name

{ ADD ... }

{ DROP ... }

[ REBALANCE [POWER integer] [WAIT | NOWAIT] ]

;

eg：(避免多次 rebalance 操作)

ALTER DISKGROUP FRA

ADD DISK 'ORCL:SDE7' NAME 'FRA_DISK5' SIZE 977 M ,

'ORCL:SDE8' NAME 'FRA_DISK6' SIZE 977 M

DROP DISK FRA_DISK1, FRA_DISK2;

----添加，删除故障组

ALTER DISKGROUP FRA

DROP DISKS IN FAILGROUP FAIL2

REBALANCE POWER 1;

ALTER DISKGROUP FRA

ADD FAILGROUP FAIL2

DISK 'ORCL:SDE11' SIZE 977 M ,'ORCL:SDE12' SIZE 977 M

DROP DISKS IN FAILGROUP FAIL1

REBALANCE POWER 11 WAIT;

ALTER DISKGROUP FRA

ADD FAILGROUP FAIL1

DISK 'ORCL:SDE9' SIZE 977 M ,'ORCL:SDE10' SIZE 977 M

REBALANCE POWER 0;

----取消磁盘删除操作：

ALTER DISKGROUP

{ diskgroup_name [, diskgroup_name ] ...

| ALL

}

UNDROP DISKS

;

eg：

ALTER DISKGROUP DATA UNDROP DISKS;

ALTER DISKGROUP DATA2, DATA3 UNDROP DISKS;

ALTER DISKGROUP ALL UNDROP DISKS;

注意：This statement cannot be used to restore disks that are bei ng dropped as the result of a  DROP DISKGROUP statement, or for disks that are being dropped using the FORCEclause.

----挂载，卸载磁盘组

ALTER DISKGROUP

{ diskgroup_name [, diskgroup_name ] ...

| ALL

}

{ MOUNT [ RESTRICTED | NORMAL ]

[ FORCE | NOFORCE ]

| DISMOUNT [ FORCE | NOFORCE ]

}

;

eg：

ALTER DISKGROUP DATA MOUNT;

ALTER DISKGROUP DATA2, DATA3 MOUNT;

ALTER DISKGROUP ALL DISMOUNT;

注意：If you try to dismount a disk group that contains  open files, the statement will fail, unless you also specify the  FORCEclause. If you  DISMOUNT FORCE, the files in the disk group become immediately inaccessible to your databases, and  any operations involving

those files will fail. In extreme cases, your database instance will abort if a disk group that it uses is forcibly dismounted.

-----查看链接客户端

V$ASM_CLIENT

asmcmd>lsct

----删除磁盘组

DROP DISKGROUP diskgroup_name

[  FORCE INCLUDING CONTENTS

| { INCLUDING | EXCLUDING } CONTENTS

]

;

eg：

DROP DISKGROUP DATA;

DROP DISKGROUP DATA2 INCLUDING CONTENTS;

DROP DISKGROUP DATA3 FORCE INCLUDING CONTENTS;

注意：

If you cannot mount a disk group but need to drop it, you can use the  FORCE INCLUDING CONTENTS option. This enables you to remove the headers on disks that belong to a disk group that cannot be mounted by a ny ASM instances. When you use the FORCE INCLUDING

CONTENTS option, the ASM instance does not atte mpt to verify that the disk group is being used by another ASM instance.

----检查磁盘组元数据的一致性

ALTER DISKGROUP diskgroup_name CHECK [ REPAIR | NOREPAIR ];

--REPAIR option to resolve inconsistencies.