oracle儲存管理之 ASM（automatic storage management）(server.102 b14231)

--asm automatic storage management
disk group
failure disk group
redundancy: normal(2 mirroring) high(3 mirroring) extent(unprotect)

--disk failure rebalance
調整 ASM_POWER_LIMIT 引數來調整rebanlance的速度
V$ASM_OPERATION --監控rebalance的速度

ASM_DISKSTRING --/dev/rdsk/* /dev/rdsk/*s[34]

ALTER DISKGROUP...MOUNT
ALTER DISKGROUP...ADD DISK

% sqlplus /nolog
SQL> CONNECT / AS sysdba
Connected to an idle instance.
SQL> STARTUP
ASM instance started

crsctl check cssd
crsctl
localconfig


V$ASM_DISKGROUP
V$ASM_DISK
V$ASM_DISKGROUP_STAT
V$ASM_DISK_STAT
V$ASM_FILE
V$ASM_TEMPLATE
V$ASM_ALIAS
V$ASM_OPERATION
V$ASM_CLIENT


% sqlplus /nolog
SQL> CONNECT / AS sysdba
Connected.
SQL> SHUTDOWN NORMAL

ALTER DISKGROUP dgroup2 REBALANCE POWER 5 WAIT;
ALTER DISKGROUP dgroup1 CHECK ALL;

ALTER DISKGROUP dgroup1 ADD ALIAS '+dgroup1/mydir/second.dbf'
FOR '+dgroup1/sample/datafile/mytable.342.3';

ALTER DISKGROUP dgroup1 RENAME ALIAS '+dgroup1/mydir/datafile.dbf'
TO '+dgroup1/payroll/compensation.dbf';

ALTER DISKGROUP dgroup1 DROP ALIAS '+dgroup1/payroll/compensation.dbf';

ALTER DISKGROUP dgroup1 DROP FILE '+dgroup1/payroll/compensation.dbf';

ALTER DISKGROUP disk_group_name ADD TEMPLATE template_name
ATTRIBUTES ([{MIRROR|HIGH|UNPROTECTED}] [{FINE|COARSE}]);[@more@]