"ORA-00314","ORA-00312"数据库问题求助。

sea2007

数据库出现如下错误信息，请教高手如何解决。
ORA-00314: log 1 of thread 1, expected sequence# 76 doesn't match 73
ORA-00312: online log 1 thread 1:
'/pa/oracle9/OraHome1/database/datafiles/owhpwt31/logg1m2owhpwt31.log'
ORA-00314: log 1 of thread 1, expected sequence# 76 doesn't match 73
ORA-00312: online log 1 thread 1:
'/pa/oracle9/OraHome1/database/datafiles/owhpwt31/logg1m1owhpwt31.log'


SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

welcome008

oerr ora 314
oerr ora 312

sea2007

当前日志状态


SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
         1          1         76    8388608          2 NO  CURRENT
      3702586 14-AUG-08

         2          1         74    8388608          2 NO  INACTIVE
      2580526 06-JUL-08

         3          1         75    8388608          2 NO  ACTIVE
      3139282 26-JUL-08

linuxerunixer

前几天也碰到了一样的问题，在网上找了几天的信息都没能解决 这个顽固的错误。让人很郁闷。

wide_ora_3590.trc: ASCII English text
[oracle@localhost udump]$ more wide_ora_3590.trc
/u01/app/oracle/admin/wide/udump/wide_ora_3590.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product10g
System name:    Linux
Node name:      localhost.localdomain
Release:        2.6.18-164.el5PAE
Version:        #1 SMP Tue Aug 18 15:59:11 EDT 2009
Machine:        i686
Instance name: wide
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 3590, image: oracle@localhost.localdomain (TNS V1-V3)

*** SERVICE NAME) 2011-06-21 06:02:25.307
*** SESSION ID159.3) 2011-06-21 06:02:25.307
Successfully allocated 2 recovery slaves
Using 543 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 39, block 2, scn 646361
  cache-low rba: logseq 39, block 30891
    on-disk rba: logseq 39, block 31111, scn 669519
  start recovery at logseq 39, block 30891, scn 0
ORA-00314: log 3 of thread 1, expected sequence# 39 doesn't match 30
ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/wide/redo03.log'
ORA-00314: log 3 of thread 1, expected sequence# 39 doesn't match 30
ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/wide/redo03.log'

jiangxiaoyu

日至文件损坏了吧

renxiao2003

重置日志文件看看。