Recovery from dbf files Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Recovery from dbf files

  1. #1
    Join Date
    Jun 2000

    Recovery from dbf files

    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.


  2. #2
    Join Date
    Aug 2002
    Try and issue recover database until cancel using backup controlfile
    and then manually supply the on line redo files

    if that does not work create a new shell db and then import your dump file

    you cannot use another db's system df for recovery
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Aug 2002
    Bangalore, India
    Online redo logs are corrupted... Only one recovery scenario is possible... Just restore from a full cold back up taken last and open the database.

    *** I havent expoloed hidden init parameters.. there is one I guess.. _skip_redo**** .. dont remember it exactly.. Try googling..

    steve > your online redo logs corrupted means, instance crash and instance will not come up.. so, no concept of import.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width