Home >Database >Mysql Tutorial >ORA-03113 故障排除

ORA-03113 故障排除

WBOY
WBOYOriginal
2016-06-07 17:30:011353browse

用ASMCA看,可用空间居然是-0.04GB。在此时shutdown abort,再启动,就只能到mount状态了,只要一open,就会ORA-03113: end-of-f

某一次在玩命往实验环境中插入数据的时候,最后撑爆了ASM。
用ASMCA看,可用空间居然是-0.04GB。
在此时shutdown abort,再启动,就只能到mount状态了,只要一open,就会
ORA-03113: end-of-file on communication channel
(本身ORA-03113原因可能很多,系统的核心参数设置不恰当, Oracle环境变量和权限, SQL,PL/SQL引起的错误, 磁盘空间满, 防火墙问题)


这种情况下救急可以直接用RMAN删除ASM上一下不必要的归档日志。
rman>connect target /
rman>delete archivelog all;


清除空间后,再启动,,OK了。

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn