ORA-00392 ORA-00312 日志正在清除故障
来源:互联网 发布:黄狮精 知乎 编辑:程序博客网 时间:2024/06/14 18:30
最近在还原Oracle数据库后open的时候碰到了ORA-00392: log 3 of thread 1 is being cleared, operation not allowed,其字面含义则是日志文件正在被清除,不允许操作。通常情况下,当我们基于不完全恢复的时候,日志文件需要被清空,而此时是正在被清空。不是很好理解啊。下面是这个问题的解决方案。
一、故障现象
SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-00392: log 3 of thread 1 is being cleared, operation not allowedORA-00312: online log 3 thread 1: '/oradata/sincnet/redo03.log'-- 查看故障描述信息SQL> ho oerr ora 0039200392, 00000, "log %s of thread %s is being cleared, operation not allowed"// *Cause: An operation encountered this online log in the middle of being// cleared. The command that began the clearing may have terminated// without completing the clearing.// *Action: If the clear command is still executing then wait for its// completion. If it terminated then reissue the clear command, or// drop the log.--下面的SQL语句表名3个日志文件都处于clearing状态SQL> select group#,bytes/1024/1024||'M',status from v$log; GROUP# BYTES/1024/1024||'M' STATUS---------- ----------------------------------------- ---------------- 1 50M CLEARING 3 50M CLEARING_CURRENT 2 50M CLEARING
二、故障处理
下面直接执行clear logfile 命令SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;Database altered.SQL> ALTER DATABASE CLEAR LOGFILE GROUP 2;Database altered.SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3;Database altered.--再次查看状态,此时状态显示为常见的几种正常状态SQL> select group#,bytes/1024/1024||'M',status from v$log; GROUP# BYTES/1024/1024||'M' STATUS---------- ----------------------------------------- ---------------- 1 50M UNUSED 3 50M CURRENT 2 50M UNUSED--再次尝试open resetlog,依旧错误,实例终止,需要upgradeSQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE optionProcess ID: 30553Session ID: 1217 Serial number: 3--查看是否存在pmon进程SQL> ho ps -ef|grep pmonoracle 30589 30440 0 16:02 pts/1 00:00:00 /bin/bash -c ps -ef|grep pmonoracle 30591 30589 0 16:02 pts/1 00:00:00 grep pmon--Author : Leshami--Blog : http://blog.csdn.net/leshami--下面尝试upgrade,因为当前基于一个11.2.0.1的备份恢复到11.2.0.4,所以需要upgradeSQL> startup upgrade;ORA-24324: service handle not initializedORA-01041: internal error. hostdef extension doesn't existSQL> SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@10134569 DBSRV]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 24 16:03:15 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup upgrade;ORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 704643976 bytesDatabase Buffers 352321536 bytesRedo Buffers 9711616 bytesDatabase mounted.Database opened.SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql; --执行升级脚本
0 0
- ORA-00392 ORA-00312 日志正在清除故障
- Oracle故障处理 ORA-16038 ORA-19502 ORA-00312
- 日志损坏处理ORA-0035 ORA-00353 ORA-00312
- DG备库ORA-01196故障-归档日志丢失恢复一则
- ORA-01591故障处理
- ORA-01220故障
- ORA-01591故障处理
- ORA-01555故障解析
- ora-3136故障处理
- ORA-01033: ORACLE 正在初始化或关闭解决方法,ORA-00313 &ORA-00312 错误 解决方案
- ORA-07445/ORA-00108故障处理
- ORA-15041,ORA-01274 故障一例
- ORA-00376/ORA-01110 故障处理办法
- ORA-16014和ORA-00312 无法归档日志解决方案
- ORA-00020,ORA-01304,ORA-27101基础故障处理
- ORA-20000故障排除手记
- ORA-01994 故障一例
- ORA-04031故障分析处理
- 设置JDeveloper工作空间
- 淘宝课程学习如何安排太原网络营销师强烈推荐
- 怎么理解Condition
- 使用Xcode7的Instruments检测解决iOS内存泄露
- 心急的C小加
- ORA-00392 ORA-00312 日志正在清除故障
- Jenkins学习总结(1)——Jenkins详细安装与构建部署使用教程
- LeetCode 206 Reverse Linked List
- larbin 的main函数
- block的使用
- 利用python库计算person相关系数
- HTML5 - 使用HTML5Forms让旧浏览器支持表单新特性,表单验证
- Android 事件分发
- Struts1的基本配置