1 2 Previous Next 16 Replies Latest reply on May 23, 2013 8:23 AM by GSun Go to original post
      • 15. Re: Media recovery of file 1
        Hemant K Chitale
        I presume that you do not have a Support Contract for your Express Edition install (which is free ?).

        You can run the command line command "dbv" which can be used to read every file and identify corrupted blocks.

        If you already have corrupted blocks and the storage and hardware are working reliably now, you would have to restore and recover the database --- assuming that your backups and/or archivelogs did not get corrupted.

        Hemant K Chitale

        Note : This is the 11.2 documentation on the "dbv" command :

        Hemant K Chitale

        Edited by: Hemant K Chitale on May 17, 2013 11:03 AM
        1 person found this helpful
        • 16. Re: Media recovery of file 1
          I lost the database. I reinstalled Oracle Database xe but the backup from my former flash recovery area didn't work. Fortunately I have a backup of the schema objects ddl and table data backup using the export utility. that was how I recovered the database losing only recent data. Regards
          1 2 Previous Next