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 -> Re: Recovery - online redo log issue (ORA-00338)

Re: Recovery - online redo log issue (ORA-00338)

From: Mihail Daskalov <mdaskalo_at_tlogica.com>
Date: 18 Apr 2002 10:07:00 -0700
Message-ID: <9f9e62ec.0204180907.726e30c9@posting.google.com>


enzoweb_at_hotmail.com (Andy) wrote in message news:<8d4033cd.0204171642.1108f368_at_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.

In this situation you should issue

alter database clear logfile group 1;

This will clear the logfile and you should be able to successfully open the database. This is possible if you take a backup after shutdown [normal|immediate|transaction]. If you do shutdown abort, you MUST backup the online redo log files as well.

HTH,
Mihail Daskalov
Brainbench MVP for Oracle Admin Received on Thu Apr 18 2002 - 12:07:00 CDT

Original text of this message

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