ITPub博客

首页 > 数据库 > Oracle > oracle存储管理之 ASM(automatic storage management)(server.102 b14231)

oracle存储管理之 ASM(automatic storage management)(server.102 b14231)

原创 Oracle 作者:polestar123 时间:2009-07-29 14:26:18 0 删除 编辑
--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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-22

  • 博文量
    110
  • 访问量
    438369