Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Recovery - online redo log issue (ORA-00338)

Recovery - online redo log issue (ORA-00338)

From: Andy <enzoweb_at_hotmail.com>
Date: 17 Apr 2002 17:42:47 -0700
Message-ID: <8d4033cd.0204171642.1108f368@posting.google.com>


I am doing some backup and recovery testing, and have a database running in noarchivelog mode.

I backed up all the files except the online redo logs as recommended by Oracle.

I started the database, added a table, then stopped the database.

I then deleted all the files, restored them from backup and when trying to start the database got:

ORA-00338: log 1 of thread 1 is more recent than controlfile ORA-00312: online log 1 thread 1:
'/smt/oradata2/bkptest/log/redolog1a.rdo'
ORA-00312: online log 1 thread 1:
'/smt/oradata3/bkptest/log/redolog1b.rdo'

Der, of course it is, because I made some changes.

So now what do I do? I have tried creating more log groups and dropping the existing ones, but it still won't let me open the database. Received on Wed Apr 17 2002 - 19:42:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US