Recoverying a corrupted system tablespace without a backup
From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Thu, 21 Oct 2010 14:12:42 -0400
Message-ID: <077c01cb714b$8ecd82b0$ac688810$_at_com>
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?
Date: Thu, 21 Oct 2010 14:12:42 -0400
Message-ID: <077c01cb714b$8ecd82b0$ac688810$_at_com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 21 2010 - 13:12:42 CDT