【ASM学习】手工删除ASM磁盘组时提示错误ORA-15039
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "SYSDATA" does not exist or is not mounted
SQL drop diskgroup flaskback;
drop diskgroup flaskback
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "FLASKBACK" does not exist or is not mounted
--查看状态显示为DISMOUNTED
SQL select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
SYSDATA DISMOUNTED
FLASKBACK DISMOUNTED
---mount磁盘组的状态
SQL alter diskgroup flaskback mount;
Diskgroup altered.
---再次删除依然提示错误 含有文件。
SQL drop diskgroup flaskback;
drop diskgroup flaskback
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "FLASKBACK" contains existing files
---只要使用含有including contents子句删除就可以了
SQL drop diskgroup flaskback including contents;
Diskgroup dropped.
---system 磁盘组也一样。。
SQL drop diskgroup sysdata including contents;
drop diskgroup sysdata including contents
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "SYSDATA" does not exist or is not mounted
SQL alter diskgroup sysdata mount;
Diskgroup altered.
SQL drop diskgroup sysdata including contents;
Diskgroup dropped.
相关文章
- django unique_together 引发内部错误
- Shell标准输出、标准错误 >/dev/null 2>&1
- Http常见错误收集
- 管理命令的错误输出
- hyper-v 尝试更改 状态时 应用程序遇到错误 无法初始化
- Atitit.故障排除系列---php 程序网站数据库错误排除流程
- Python语言学习:Python语言学习之迭代/递归/OS输入输出/错误&异常处理的简介、案例应用之详细攻略
- Python语言学习:解决python版本升级问题集合(python2系列→Python3系列)导致错误的总结集合
- 已解决SQL错误(1050) : Table ‘test1‘ already exists
- Python Flask框架学习15:Flask 重定向和错误
- 学习内核驱动程序的错误及其解决方案的出现,
- c++ clr编译dll在c#调用时出现“试图加载不正确的格式”“找不到dll”错误的解决
- FDR错误发现率-P值校正学习[转载]
- Java初学者一定要注意的问题,这些错误你犯过哪些?永远不要停止学习。
- Python学习笔记五之错误与异常处理、面向对象实例