startup open error message

[pravin]

oracle 8.1.7
OS - NT
Mode - archivelog

I have several instances on this windows NT .
All the instances have started and the database is open.

For this particular instance testing i am getting this error.

SVRMGR> alter database open;
alter database open
*
ORA-00314: log 1 of thread 1, expected sequence# doesn't match
ORA-00312: online log 1 thread 1: 'D:\ORACLE817\ORADATA\TESTING\REDO03.LOG'

what is error and how this can be resolved.

[sambavan]

Do you keep backups on this? On such case, startup the database on mount, do a recovery until cancel and then do alter database open resetlogs;

The error was because that your controlfile and the redo log files are not in sync. You either recoverd the controlfile and did not recover the online log file that you backed up or vice versa.

Sam

[pravin]

Did the steps as said by sambavan Thanks sambhavan

Case closed