--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@]
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70612/viewspace-1024710/
,如需转载,请注明出处,否则将追究法律责任。