ORA-00392ORA-00312日志正在清除故障
网络编程 2021-07-05 16:08www.168986.cn编程入门
这篇文章主要介绍了ORA-00392ORA-00312日志正在清除故障的相关资料,需要的朋友可以参考下
最近在还原Oracle数据库后open的时候碰到了ORA-00392: log 3 of thread 1 is being cleared, operation not allowed,其字面含义则是日志文件正在被清除,不允许操作。
通常情况下,当我们基于不完全恢复的时候,日志文件需要被清空,而此时是正在被清空。不是很好理解啊。狼蚁网站SEO优化是这个问题的解决方案。
一、故障现象
<code class="hljs vhdl">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 allowed ORA-00312: online log 3 thread 1: '/oradata/sinc/redo03.log' -- 查看故障描述信息 SQL> ho oerr ora 00392 00392, 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 mand that began the clearing may have terminated // without pleting the clearing. // Action: If the clear mand is still executing then wait for its // pletion. If it terminated then reissue the clear mand, or // drop the log. --狼蚁网站SEO优化的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</code>
二、故障处理
<code class="hljs vhdl"><code class="hljs vhdl">狼蚁网站SEO优化直接执行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,依旧错误,实例终止,需要upgrade SQL> alter database open resetlogs; alter database open resetlogs ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Process ID: 30553 Session ID: 1217 Serial number: 3 --查看是否存在pmon进程 SQL> ho ps -ef|grep pmon oracle 30589 30440 0 16:02 pts/1 00:00:00 /bin/bash -c ps -ef|grep pmon oracle 30591 30589 0 16:02 pts/1 00:00:00 grep pmon --Author : Leshami --Blog : http://blog.csdn./leshami --狼蚁网站SEO优化尝试upgrade,因为当前基于一个11.2.0.1的备份恢复到11.2.0.4,所以需要upgrade SQL> startup upgrade; ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist SQL> SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@10134569 DBSRV]$ sqlplus / as sysdba SQLPlus: Release 11.2.0.4.0 Production on Wed Feb 24 16:03:15 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup upgrade; ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2260088 bytes Variable Size 704643976 bytes Database Buffers 352321536 bytes Redo Buffers 9711616 bytes Database mounted. Database opened. SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql; --执行升级脚本</code></code>
关于ORA-00392ORA-00312日志正在清除故障的教程长沙网络推广就给大家介绍这么多,希望对大家有所帮助!
编程语言
- 甘肃哪有关键词排名优化购买方式有哪些
- 甘肃SEO如何做网站优化
- 河南seo关键词优化怎么做电话营销
- 北京SEO优化如何做QQ群营销
- 来宾百度关键词排名:提升您网站曝光率的关键
- 卢龙关键词优化:提升您网站排名的策略与技巧
- 山东网站优化的注意事项有哪些
- 四川整站优化怎样提升在搜索引擎中的排名
- 疏附整站优化:提升网站性能与用户体验的全新
- 海南seo主要做什么工作售后服务要做到哪些
- 荣昌百度网站优化:提升您网站的搜索引擎排名
- 河北seo网站排名关键词优化如何做SEO
- 江西优化关键词排名推广售后保障一般有哪些
- 古浪SEO优化:提升你的网站可见性
- 西藏网站排名优化怎么把网站排名在百度首页
- 如何提升阳东百度快照排名:详尽指南