[suse-oracle] Corrupted/Missing Rollback Tablespace

From: Matthew Iskra (mhiskra@cdi-hq.com)
Date: Wed Oct 31 2001 - 09:17:15 PST

  • Next message: Edrik: "Re: [suse-oracle] Help starting Oracle DB" 

    From: "Matthew Iskra" <mhiskra@cdi-hq.com>
Date: Wed, 31 Oct 2001 09:17:15 -0800
Message-ID: <MEEJIIGPPKAOBBFNJGHPEEBBCBAA.mhiskra@cdi-hq.com>
Subject: [suse-oracle] Corrupted/Missing Rollback Tablespace

    A tricky situation.

    I have an Oracle 8i database on a SuSE 7.0 box. The original DBA added a new
    file and tablespace, called RBS, to hold additional rollback segments. A
    programmer tried to export from Access using ODBC and but the data directly
    into the oracle database. Something went wrong and the load failed. In the
    process of 'fixing' the database and undoing the load, the RBS tablespace
    got corrupted. Eventually I get called in. Recognizing that we do not need
    the data in the segment, I attempted an offline drop. That worked, although
    in hindsight it was probably not the correct thing to do. I then tried
    dropping the user with cascade options to eliminate all the bad data. It
    won't work - the database still wants the missing rollback segment to be
    online which is now impossible.

    There is data in other tables that we need, so I do not want to reinstall
    oracle is I don't have to.

    Any ideas?

    --Matthew Iskra

    This archive was generated by hypermail 2.1.0 : Wed Oct 31 2001 - 09:17:00 PST