Oracle ASM disk Group Management

I. Create a disk group

Command:

Create diskgroup diskgroup_name

<High | normal | external> redundancy

Failgroup failgroup_name disk 'disk _ nmae' name asm_disk_name

...

;

Note:

Limit on the number of failgroup fault groups:

HIGH ---------- failgroup> = 3

NORMAL ---------- failgroup> = 2

EXTERNAL -------- failgroup = 0 the fault group cannot be specified)

E. g:

1. high redundancy)

Create diskgroup dgdata1

High redundancy

Failgroup dgdata1_fg1 disk 'ORCL: DISK1' name dgdata1_fg000001

Failgroup dgdata1_fg2 disk 'ORCL: DISK2' name dgdata1_fg2_01

Failgroup dgdata1_fg3 disk 'ORCL: DISK3 'name dgdata1_fg3_01;

You can also add multiple disks to a fault group)

2. General redundancy normal redundancy)

Create diskgroup dgdata2

Normal redundancy

Failgroup dgdata2_fg1 disk 'ORCL: DISK4 'name dgdata2_fg000001

Failgroup dgdata2_fg2 disk 'ORCL: DISK5 'name dgdata2_fg2_01;

3. external redundancy)

Create diskgroup dgdata3

External redundancy

Disk 'orcl: disk6' name dgdata3_01;

Ii. delete a disk group

Command:

Drop diskgroup diskgroup_name;

Note:

When deleting a disk group, the disk group must be mounted)

E.g .:

Drop diskgroup dgdata1;

Iii. MOUNT a disk)

Command:

Alter diskgroup diskgroup_name mount; # mount sepcify diskgroup

Or

Alter diskgroup all mount;

# Mount all diskgroup that values are from parameter asm_diskgroups.

E.g .:

Alter diskgroup dgdata1 mount;

4. Detach a disk DISMOUNT)

Command:

Alter diskgroup diskgroup_name dismount; # dismount sepcify diskgroup

Or

Alter diskgroup all dismount;

# Dismount all diskgroup that values are from parameter asm_diskgroups.

E.g .:

Alter diskgroup dgdata1 dismount;

Or

Alter diskgroup dgdata1 dismount force;

# Force DISMOUNT. If any data is used in this disk group.

5. modify the number of disk groups

Command:

1. Add a disk to the specified fault group

Alter diskgroup diskgroup_name

Add failgroup failgroup_name disk 'disk _ name' name asm_disk_name [force];

2. Add a new fault group to the disk

Alter diskgroup dgdata2

Add disk 'disk _ name' name asm_disk_name;

# The fault group name is not specified. The name is the same as the name field.

Or

Alter diskgroup dgdata2

Add disk 'disk _ name'; # The fault group name and ASM disk name are not specified. The names are uniformly specified by the system.

3. delete a disk

Alter diskgroup diskgroup_name

Drop disk asm_disk_name;

4. The fault group deletes the disk and adds it to the new disk.

Alter diskgroup diskgroup_name

Drop disk 'asm _ disk_name'

Add failgroup failgroup_name disk 'disk _ name' name asm_disk_name [force];

# The purpose is to reduce resource consumption for rebalancing.

Note:

1. If the fault group name is not specified when a disk is added, the system default fault group name is the name after the name. If

The name field is not specified.

2. the disk will be rebalanced when it is added or deleted.

3. force indicates that the disk is forcibly pulled from another disk group and added to the disk group in the current operation. Magnetic pulling required

Disk group DISMOUNT ).

4. When a disk is deleted and added to a new disk, the disk group is rebalanced only once. If the disk is deleted,

To add a new disk, You need to rebalance it twice.

E.g .:

1. alter diskgroup dgdata2

Add failgroup dgdata2_fg1 disk 'orcl: disk7' name dgdata2_fg000002;

2. alter diskgroup dgdata2

Add disk 'orcl: disk7' name dgdata2_fg000002;

# The system automatically generates a fault group name with the same name as the name after the name, that is, the name dgdata2_fg000002

3. alter diskgroup dgdata2

Add disk 'orcl: disk7'; # the system automatically generates the fault group name and the ASM disk name, which are the same.

4. alter diskgroup dgdata2

Drop disk 'orcl: disk2'

Add failgroup dgdata2_fg2 disk 'ORCL: DIS3 'name dgdata2_fg2_03;

Oracle video tutorial follow: http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html