Recoverying a corrupted system tablespace without a backup

  • From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
  • To: "'Oracle-L Group'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Oct 2010 14:12:42 -0400

A client of mine has a dev database (10g on linux) that was never backed up
and due to a controller issue has a corrupted system tablespace. DBV shows 8
corrupted blocks. Is there a way to open the database just long enough to
export some key tables with some important configuration data? All the
tables are in one 2.1gb datafile without corrupted blocks. Are there any
free/cheap unloader utilities?

 

Thanks,

Ken Naim

Other related posts: