top of page
CerebroSQL

Oracle:

ALTER DISKGROUP

ALTER DISKGROUP
{ diskgroup_name
{ { { add_disk_clause | drop_disk_clause }
[, { add_disk_clause | drop_disk_clause } ]...
| resize_disk_clause
} [ rebalance_diskgroup_clause ]
| disk_online_clause
| disk_offline_clause
| rebalance_diskgroup_clause
| check_diskgroup_clause
| diskgroup_template_clauses
| diskgroup_directory_clauses
| diskgroup_alias_clauses
| diskgroup_volume_clauses
| diskgroup_attributes
| modify_diskgroup_file
| drop_diskgroup_file_clause
| usergroup_clauses
| user_clauses
| file_permissions_clause
| file_owner_clause
}
| { diskgroup_name [, diskgroup_name ] ...
| ALL
} { undrop_disk_clause
| diskgroup_availability
| enable_disable_volume
}
} ;

Example

ALTER DISKGROUP dgroup_01
ADD DISK '/devices/disks/d100';
ALTER DISKGROUP dgroup_01
DROP DISK dgroup_01_0000;
ALTER DISKGROUP dgroup_01
UNDROP DISKS;
ALTER DISKGROUP dgroup_01
RESIZE ALL
SIZE 36G;
ALTER DISKGROUP dgroup_01
REBALANCE POWER 11 WAIT;
ALTER DISKGROUP dgroup_01
CHECK ALL
REPAIR;
ALTER DISKGROUP dgroup_01
ADD TEMPLATE template_01
ATTRIBUTES (UNPROTECTED COARSE);
ALTER DISKGROUP dgroup_01
MODIFY TEMPLATE template_01
ATTRIBUTES (FINE);
ALTER DISKGROUP dgroup_01
DROP TEMPLATE template_01;
ALTER DISKGROUP dgroup_01
ADD DIRECTORY '+dgroup_01/alias_dir';
ALTER DISKGROUP dgroup_01
ADD ALIAS '+dgroup_01/alias_dir/datafile.dbf'
FOR '+dgroup_01.261.1';
ALTER DISKGROUP dgroup_01
DISMOUNT FORCE;
ALTER DISKGROUP dgroup_01
MOUNT;

bottom of page