How To Resize An ASM Disk On Release 10.2.0.X

来源:互联网 发布:淘宝马云能占多少股份 编辑:程序博客网 时间:2024/06/11 03:45

 

 

1) Please backup the database(s) contained inside the associated diskgroup.

2) Then shutdown the databases contained inside the associated diskgroup.

3) Dismount the associated diskgroup to verify no client database connections are accessing this specific diskgroup:

SQL> alter diskgroup <diskgroup> dismount;



4) Resize your physical disk/LUN at OS/hardware level.

5) Mount back the diskgroup:

SQL> alter diskgroup <diskgroup> mount;



6) Then resize the ASM disk as the following example:

 

SQL> ALTER DISKGROUP <diskgroup> RESIZE DISK <disk name> <size>M REBALANCE POWER <1-11>;

SQL> ALTER DISKGROUP DATA RESIZE DISK DISK_A1 SIZE 5000 M REBALANCE POWER 11;

 

 

 

 

 

From Oracle

-------------------------------------------------------------------------------------------------------

Blog http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

聊天 群:40132017   聊天2群:69087192

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

原创粉丝点击