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
-------------------------------------------------------------------------------------------------------
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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
Oracle 10.2 ASM 最佳实践 ...Rebalance and Redistribution Files and Aliases Enhanced management for ASM ASM Command Line Interface (ASMCMD) DBMS_FILE_TRANSFER Utility Enhancements ......
asm-1.3.3.jar, asm-1.3.4.jar, asm-1.3.5.jar, asm-1.4.1.jar, asm-1.4.2.jar, asm-1.4.3.jar, asm-1.4.jar, asm-1.5.1.jar, asm-1.5.2.jar, asm-1.5.3.jar, asm-2.0.jar, asm-2.1.jar, asm-2.2.1-sources.jar, asm...
汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM
包含如下oracleasm包: kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm oracleasm-2.0.8-4.el6_6.src.rpm oracleasm-2.0.8-6.el6_7.src.rpm oracleasm-2.0.8-8.el7.src.rpm oracleasm-2.0.8-15.el7.centos.src.rpm ...
EditPlus是很好用的编辑软件 但网上下的很多EP版本需要自己添加asm.acp,asm.stx,不是很方便 这个里面附带了asm.acp,asm.stx
赠送jar包:asm-9.1.jar; 赠送原API文档:asm-9.1-javadoc.jar; 赠送源代码:asm-9.1-sources.jar; 赠送Maven依赖信息文件:asm-9.1.pom; 包含翻译后的API文档:asm-9.1-javadoc-API文档-中文(简体)版.zip; ...
开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具...
盈高入网要求规范管理系统ASM6000产品说明书V1.1.pdf盈高入网要求规范管理系统ASM6000产品说明书V1.1.pdf盈高入网要求规范管理系统ASM6000产品说明书V1.1.pdf盈高入网要求规范管理系统ASM6000产品说明书V1.1.pdf盈高...
ASM1061 原理图 PCIE转2 port Sata芯片 ASM1061 原理图 PCIE转2 port Sata芯片
asm-util-1.3.4.jar, asm-util-1.3.5.jar, asm-util-1.4.1.jar, asm-util-1.4.3.jar, asm-util-1.5.1.jar, asm-util-1.5.2.jar, asm-util-1.5.3.jar, asm-util-2.0.jar, asm-util-2.1.jar, asm-util-2.2.1-sources....
ASM4使用指南 ASM GUIDE
ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网安全解决方案ASM内网...
ASM实例+ASM数据库安装(Win8+Ora10) 1 第一篇 创建未格式化的磁盘分区 1 1.1 打开压缩卷窗口 1 1.2 输入卷大小 3 1.3 选择挂载目录 4 1.4 格式化分区选项 5 1.5汇总信息 6 1.6分区完成后磁盘情况 7 1.7挂载目录...
赠送jar包:asm-4.2.jar; 赠送原API文档:asm-4.2-javadoc.jar; 赠送源代码:asm-4.2-sources.jar; 赠送Maven依赖信息文件:asm-4.2.pom; 包含翻译后的API文档:asm-4.2-javadoc-API文档-中文(简体)版.zip; ...
oracle不使用oracleasm的包配置ASM磁盘配置方法
ASM7使用指南;
asm1053 asm1153e datasheet asm1053 asm1153e 手册
cglib动态代理模式jar包 cglib-2.2.jar asm-tree.jar asm-commons.jar asm.jar
ASM1166datasheet.pdf
asm-analysis-5.0.3.jar;asm-analysis-5.0.3.jar;asm-analysis-5.0.3.jar