oracle 11g asm 基本操作
来源:互联网 发布:管理货的软件 编辑:程序博客网 时间:2024/06/08 15:46
oracle 11g asm 基本操作
相关视图:
v$asm_diskgroup
v$asm_disk
v$asm_operation
----添加,删除磁盘
ALTER DISKGROUP diskgroup_name
{ ADD ... }
{ DROP ... }
[ REBALANCE [POWER integer] [WAIT | NOWAIT] ]
;
eg:(避免多次 rebalance 操作)
ALTER DISKGROUP FRA
ADD DISK 'ORCL:SDE7' NAME 'FRA_DISK5' SIZE 977 M ,
'ORCL:SDE8' NAME 'FRA_DISK6' SIZE 977 M
DROP DISK FRA_DISK1, FRA_DISK2;
----添加,删除故障组
ALTER DISKGROUP FRA
DROP DISKS IN FAILGROUP FAIL2
REBALANCE POWER 1;
ALTER DISKGROUP FRA
ADD FAILGROUP FAIL2
DISK 'ORCL:SDE11' SIZE 977 M ,'ORCL:SDE12' SIZE 977 M
DROP DISKS IN FAILGROUP FAIL1
REBALANCE POWER 11 WAIT;
ALTER DISKGROUP FRA
ADD FAILGROUP FAIL1
DISK 'ORCL:SDE9' SIZE 977 M ,'ORCL:SDE10' SIZE 977 M
REBALANCE POWER 0;
----取消磁盘删除操作:
ALTER DISKGROUP
{ diskgroup_name [, diskgroup_name ] ...
| ALL
}
UNDROP DISKS
;
eg:
ALTER DISKGROUP DATA UNDROP DISKS;
ALTER DISKGROUP DATA2, DATA3 UNDROP DISKS;
ALTER DISKGROUP ALL UNDROP DISKS;
注意:This statement cannot be used to restore disks that are bei ng dropped as the result of a DROP DISKGROUP statement, or for disks that are being dropped using the FORCEclause.
----挂载,卸载磁盘组
ALTER DISKGROUP
{ diskgroup_name [, diskgroup_name ] ...
| ALL
}
{ MOUNT [ RESTRICTED | NORMAL ]
[ FORCE | NOFORCE ]
| DISMOUNT [ FORCE | NOFORCE ]
}
;
eg:
ALTER DISKGROUP DATA MOUNT;
ALTER DISKGROUP DATA2, DATA3 MOUNT;
ALTER DISKGROUP ALL DISMOUNT;
注意:If you try to dismount a disk group that contains open files, the statement will fail, unless you also specify the FORCEclause. If you DISMOUNT FORCE, the files in the disk group become immediately inaccessible to your databases, and any operations involving those files will fail. In extreme cases, your database instance will abort if a disk group that it uses is forcibly dismounted.
-----查看链接客户端
V$ASM_CLIENT
asmcmd>lsct
----删除磁盘组
DROP DISKGROUP diskgroup_name
[ FORCE INCLUDING CONTENTS
| { INCLUDING | EXCLUDING } CONTENTS
]
;
eg:
DROP DISKGROUP DATA;
DROP DISKGROUP DATA2 INCLUDING CONTENTS;
DROP DISKGROUP DATA3 FORCE INCLUDING CONTENTS;
注意:
If you cannot mount a disk group but need to drop it, you can use the FORCE INCLUDING CONTENTS option. This enables you to remove the headers on disks that belong to a disk group that cannot be mounted by a ny ASM instances. When you use the FORCE INCLUDING CONTENTS option, the ASM instance does not atte mpt to verify that the disk group is being used by another ASM instance.
----检查磁盘组元数据的一致性
ALTER DISKGROUP diskgroup_name CHECK [ REPAIR | NOREPAIR ];
--REPAIR option to resolve inconsistencies.
- oracle 11g asm 基本操作
- Oracle 11g dataguard asm to asm
- 11g+ASM oracle 安装
- Oracle 11g ASM 特性
- oracle 11g asm安装
- oracle 11g 基本操作代码
- oracle 11g 的一些基本操作:
- Oracle 11g R2 ASM:了解 Oracle ASM 基本概念
- 连接 Oracle 11G R2 ASM实例
- 单用户安装Oracle 11g 单机ASM
- Oracle 11g ASM Command Enhancement
- ORACLE 11G ASM DISKGROUP COMPATIBILITY
- Oracle-11g学习5 - ASM安装
- Oracle 11g ASM详细配置
- [oracle]Oracle 11g DG搭建(备库使用ASM)
- 在oracle 11g r2中要使用ASM,是不是一定要安装Grid Infrastructure?【基本问题解惑】
- ASM基本操作
- 转 -- Oracle RAC系列之:ASM基本操作维护
- SQLite与SQLServer的区别
- Tomcat优化详解
- QueryPerformanceCounter精确计算执行时间
- Unity3D如何实现点击物体替换贴图。
- 【屌丝学习笔记】第十三天 JAVA基础
- oracle 11g asm 基本操作
- 内存管理一
- PCH file built from a different branch ((clang-425.0.24)) than the compiler
- What every SharePoint administrator needs to know about Alternate Access Mappings (Part 1 of 3)
- Linux内存管理之mmap详解
- 开源中间件tomcat服务器安全配置基线指导
- lucene产生的索引文件格式详解
- Java线程同步如何才能排除阻塞
- 【转】USB的描述符介绍