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

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

If you're running in noarchivelog mode you can only perform offline (cold) backup.

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

For offline backup, you must include controlfile(s), datafiles and online
redo logs. I believe the recommendation is for online (hot) backups.

>
> 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 - 21:26:31 CDT