Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Unhappy Unanswered: Urgent Help....File corrupted.........

    Hi Folks,

    On my oracle server the file named system01.dbf has become corrupted...
    I dont have a backup...
    Any way to rescue my database.....


    Thankx in advance........
    Sree

  2. #2
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    24
    Not sure what type of corruption you have but if the error you are getting is datafile needs recovery, you could try recovering the file with the information in the redo logs.

    From mounted state run:

    sqlplus> recover datafile 'path:\system01.dbf';

    If it is successfully recovered you should be able to open the database.

  3. #3
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Unhappy File corruption

    Hi,

    I tried using the recover command but it is saying that the file is in use.
    Any method to avoid this error...

    Thanx
    Sree

Posting Permissions

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