Miscellaneous Disk Group Maintenance Enhancements

Miscellaneous Disk Group Maintenance Enhancements

• The CREATE DISKGROUP and ALTER DISKGROUP commands include a new ATTRIBUTE clause (compatible, disk_repair_time, au_size).
• The CHECK clause of the ALTER DISKGROUP command has been simplified so there are only two options, NOREPAIR and REPAIR, available, with NOREPAIR as the default. Summarized errors are displayed, with full error messages writen to the alert log.

·         ALTER DISKGROUP data CHECK; -- Like NOREPAIR

·         ALTER DISKGROUP data CHECK NOREPAIR;

ALTER DISKGROUP data CHECK REPAIR;

• Disk groups can now be mounted in restricted mode, which can improve performance of some maintenance tasks.
• The ALTER DISKGOUP command now includes ONLINE and OFFLINE clauses so disks can be taken offline for repair before being brought back online.

·         -- Individual disks.

·         ALTER DISKGROUP data OFFLINE DISK 'disk_0000', 'disk_0001';

·         ALTER DISKGROUP data ONLINE DISK 'disk_0000', 'disk_0001';

·          

·         -- Failure groups.

·         ALTER DISKGROUP data OFFLINE DISKS IN FAILGROUP 'fg_0000';

·         ALTER DISKGROUP data ONLINE DISKS IN FAILGROUP 'fg_0000';

·          

·         -- Bring online all disks in disk group.

ALTER DISKGROUP data ONLINE ALL;

• Disk groups that can't be mounted by ASM can now be dropped using the FORCE keyword of the DROP DISKGROUP command.

DROP DISKGROUP data FORCE;