Recover system.dbf with no backup - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Recover system.dbf with no backup

  1. #11
    Join Date
    Aug 2001
    Posts
    267
    Might be your solution works only if the file is damaged due to h/w failure .
    Raghu

  2. #12
    Join Date
    Mar 2001
    Posts
    144
    Nope. It works on data black corruption. With hardware failure you need a backup - no questions about that.

    I am curious though: the error message you posted:

    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'D:\KELLER\KELLER\SYSTEM01.DBF'

    1) Oracle can't find the file or something else was locking it.
    Look for the drive and directory. Was it renamed? is it there?

    2) Guess this is Windows NT/2000 so look in the Task Manager and check to see if Oracle.exe is running and if it is kill the process or reboot.

    what does the dbwr trace file say?

  3. #13
    Join Date
    Aug 2001
    Posts
    267
    Another simulation ..I opened my system1.dbf edited it ...removed some blocks ..tried to startup ..same error message ..

    Raghu

  4. #14
    Join Date
    Aug 2001
    Posts
    267
    Let me try that ..
    Raghu

  5. #15
    Join Date
    Mar 2001
    Posts
    144
    You manually edited the system01.dbf? with notepad?

  6. #16
    Join Date
    Aug 2001
    Posts
    267
    No ..Notepad can't open ..Some other editer ..
    Raghu

  7. #17
    Join Date
    Mar 2001
    Posts
    144
    But you edited a binary file. There is no real way to recover any data from this database now. You will need to rebuild. Sorry.

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