Sometimes it can happen that the ASM contains empty system directories whichcannot be removed. According to Note 3751057.8(ALTER DISKGROUP DROP DIRECTORY FORCE removes system aliases) the system generated directories should be removed automatically as soon as all it's files are removed. However this does not happen sometimes and a manualdirectory removal will fail :
SQL>setpages2000
SQL>SELECTlevel,dir,sys,substr(lpad('',2*level,'')||CONCAT('+'||gname,
SYS_CONNECT_BY_PATH(aname,'/')),1,60)full_path
FROM(SELECTg.namegname,a.parent_indexpindex,a.nameaname,
a.reference_indexrindex,a.ALIAS_DIRECTORYdir,a.SYSTEM_CREATEDsys
FROMv$asm_aliasa,v$asm_diskgroupg
WHEREa.group_number=g.group_number)
STARTWITH(MOD(pindex,POWER(2,24)))=0
CONNECTBYPRIORrindex=pindex
ORDERBYrtrim(ltrim(full_path))desc,levelasc;
3NY+DATA/UDWH/DATAFILE/ADASTRA.376.624105133
2YY+DATA/UDWH/DATAFILE
3NY+DATA/UDWH/CONTROLFILE/Current.486.624103637
3NY+DATA/UDWH/CONTROLFILE/Current.479.624103637
3NY+DATA/UDWH/CONTROLFILE/Current.434.624103637
2YY+DATA/UDWH/CONTROLFILE
1YY+DATA/UDWH
1YY+DATA/TDWH
2NN+DATA/IDWH/spfileIDWH.ora
2NN+DATA/IDWH/control03.ctl
2NN+DATA/IDWH/control02.ctl
2NN+DATA/IDWH/control01.ctl
The TDWH directory from the above list is empty but cannot be removed :
ASMCMD>cdtdwh
ASMCMD>ls
ASMCMD>cd..
ASMCMD>rm-rftdwh
ORA-15032:notallalterationsperformed
ORA-15177:cannotoperateonsystemaliases(DBDERROR:OCIStmtExecute)
alterdiskgroupDATAdropdirectory'+DATA/TDWH'FORCE;
ORA-15032:notallalterationsperformed
ORA-15177:cannotoperateonsystemaliases(DBDERROR:OCIStmtExecute)
A solution to remove these directories is to recreate the ASM diskgroups but this is not something one would do very often especially when the ASM is used by production databases.
Solution
Either:
Create a new database with the DBCA having the same name as the old directory and subsequently drop the database with the DBCA.
Or:
Create a dummy tablespace having a datafile within the directory to be dropped, drop the tablespace and then remove the datafile using the ASMCMD tool. The old directory will be removed automatically.
There is a scenario when there are left behind directories after the database is dropped using RMAN's command "drop database including backups [noprompt];". When one falls into this there is no way out but to recreate the diskgroups. This problem is being investigated in Bug 6606689. To avoid this issue one should run the following two commands instead of "DROP DATABASE INCLUDING BACKUPS;":
RMAN> delete backupset;
RMAN> drop database;
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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
How to view and edit data on ASM using BBED
2020年oracle12C 063最新题库 word... when one or more file directory paths are accidentally deleted from an ASM disk group E. when all the ASM disk groups for the ASM instance are lost Correct Answer: ADE
WLADX Z80 empty template
linux下intel asm 转at & t asm
PR7673: Some versions of GCC support an empty clobbers section Source Code for Linux v2.13.6.
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...
主题:Bring Native to the Web: an introduction to Emscripten and asm.js 演讲人:张频,谋智网络(Mozilla)软件经理 演讲介绍:Emscripten 是 Mozilla 推出的一个开源编译工具,它能将 C/C++ 程序编译为 ...
Oracle RAC增加ASM盘,创建表空间
Database Initora parameters to support ASM ASM and database shutdown dependencies ASM and database deployment Best Practices Storage Management and Allocation Rebalance and Redistribution Files ...
汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM
System.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
开发工具 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开发工具...
ASM4使用指南 ASM GUIDE
ASM1061 原理图 PCIE转2 port Sata芯片 ASM1061 原理图 PCIE转2 port Sata芯片
赠送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-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....
java字节码操作相关工具asm asm-util asm-tree asm-analysis
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挂载目录...