ASM Fast Rebalance

 

This article talks about the 11g new feature - ASM Fast rebalance and how to implement in 11g ASM Instance

 

 

       In 11g, you can use the STARTUP RESTRICT command to control access to an ASM instance while you perform maintenance. This startup option is used to implement ASM Fast Rebalance feature. Rebalance operations that occur while a disk group is in RESTRICTED mode eliminate the lock and unlock extent map messaging between ASM instances in Oracle RAC environments.

       When an ASM instance is started with 'STARTUP RESTRICT' option and is active in this mode, all of the disk groups are mounted in RESTRICTED mode which prevents databases from connecting to the ASM instance. In addition, the restricted clause of the ALTER SYSTEM statement is disabled for the ASM instance.

Given below is an example to show ASM Fast Rebalance Feature.


Startup ASM instance in Restricted mode

SQL> startup restrict;
ASM instance started
Total System Global Area 92065792 bytes
Fixed Size 1297984 bytes
Variable Size 65601984 bytes
ASM Cache 25165824 bytes


Now in case you wish to mount the Disk group in normal mode , you get following errors

SQL> alter diskgroup dgext11gasm mount;
alter diskgroup dgext11gasm mount
*
ERROR at line 1:
ORA-15251: only restricted mount is allowed in the ASM instance


You need to use restricted clause along with mount option.

 

SQL> alter diskgroup dgext11gasm mount restricted;
Diskgroup altered.

SQL> alter diskgroup dgext11gasm rebalance;
Diskgroup altered.


If ASM diskgroup is mounted in restricted mode,Database Instance will not be able to access files residing in the ASM Diskgroup

SQL> startup
ORACLE instance started.

Total System Global Area 418484224 bytes
Fixed Size 1300200 bytes
Variable Size 268437784 bytes
Database Buffers 142606336 bytes
Redo Buffers 6139904 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '+DGEXT11GASM/o11g/datafile/test.256.627345731'


       Unlike normal Database Instance, alter system disable restricted session is disabled for ASM Instance.
       You need to shutdown and startup ASM Instance in Normal mode to access files reside in the ASM Diskgroup for Database Instance

 

ASM Instance
=============
SQL> alter system disable restricted session;
alter system disable restricted session
*
ERROR at line 1:
ORA-15000: command disallowed by current instance type

SQL>shutdown immediate
SQL>startup

 

 

 

 

 

From Oracle

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

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

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

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

聊天 群:40132017   聊天2群:69087192

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值