ORA-00314: log 2 of thread 1, expected sequence# doesn't ORA-00312: online log 2 thread 1:
来源:互联网 发布:mac os iso 编辑:程序博客网 时间:2024/05/20 04:30
在测试机器上启动发现没起来,手动启动报错:
C:\Users\lenovo>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 16 10:13:28 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> select status from v$instance;STATUS------------MOUNTEDSQL> alter database open;alter database open*ERROR at line 1:ORA-00314: log 2 of thread 1, expected sequence# doesn't matchORA-00312: online log 2 thread 1:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'应该是日志组group2 损坏了,导致这个错误:
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------ 1 1 83 52428800 1 NO CURRENT 303819155 17-MAR-14 3 1 82 52428800 1 YES INACTIVE 303798283 17-MAR-14 2 1 81 52428800 1 YES INACTIVE 303774258 17-MAR-14SQL>
直接把这个归档状态的redolog清理了应该就可以了
SQL> alter database clear logfile group 2;Database altered.SQL> alter database open;Database altered.SQL> select status from v$instance;
0 0
- ORA-00314: log 2 of thread 1, expected sequence# doesn't ORA-00312: online log 2 thread 1:
- ORA-00314: log 20 of thread 1, expected sequence# 108055 doesn't match 108053
- ORA-16014: log 1 sequence# 23308 not archived, no available destinations,ORA-00312: online log 1 thread 1:
- ORA-00600 Recovery of Online Redo Log: Thread 1 Group 2 Seq 128 Reading mem 0 错误特殊恢复
- ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
- Oracle:ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
- ORA-00312: online log 6 问题
- Thread 1 cannot allocate new log, sequence 210510
- ORA-16038: log 2 sequence# 1191 cannot be archived
- ORA-16038: log 2 sequence# 41 cannot be archived
- ORA-16014: log 2 sequence# not archived, no available destinations"
- ORA-16038: log 1 sequence# 59 cannot be archived
- ORA-16038: log 1 sequence# *cannot be archived
- Thread 1 cannot allocate new log
- Thread 1 cannot allocate new log
- ORA-00312: 联机日志 2 线程 1: 'E:/ORACLE/ORADATA/TEST/REDO02.LOG'
- ORA-00312: 联机日志 2 线程 1:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
- LGWR: Failed to archive log X thread 1 sequence 151016 (16086)
- listview item 左右滑动
- iOS开发:打包应用程序
- BigDecimal类的加减乘除
- Eclipse中10个最有用的快捷键组合
- 开始学数据结构——(五):二分查找 ,非递归
- ORA-00314: log 2 of thread 1, expected sequence# doesn't ORA-00312: online log 2 thread 1:
- case when then 中判断null的方法
- 报错 java.lang.OutOfMemoryError: PermGen space
- 选择的边界
- 并发性和并行性的区别
- C++模拟post HTTP编程
- android设置字体样式
- include与jsp:include区别
- 小 丑