We have a production database on oracle 8i running on Windows NT in nonarchivelog mode.It 's online redo logs are corrupted .Redo logs are not multiplexed.
ORA-00314 (LOG 3 THREAD 1 ,EXPECTED SEQUENCE #1091 DOES NOT MATCH 1087)Is showing on startup.
on applying redo logs BY ISSUING COMMAND -"RECOVER DATABASE UNTIL CANCEL" it also gives same error message.
ORA-01194 (File System.dbf needs more recovery to be consitent.)is showing on trying to recover by alter database open resetlogs.
I think my system.dbf is also in inconsistent state.How I can restore.
Is it possible to take any other database's System.dbf having the same schema and replace and recover.
I have a logical backup(dmp) which is old enough.