Re: HELP - corrupted test scheme - V 8.05

From: Julie Warden <>
Date: Sun, 12 Jul 2009 22:21:59 -0400
Message-ID: <>

On Sun, 12 Jul 2009 23:34:15 +0100, Palooka <> wrote:

>Palooka wrote:
>> Julie Warden wrote:
>>> Group,
>>> We have an orphan application, I set up about 10 years ago. Meanwhile
>>> another secretive DBA worked it and modified everything - I'm sure
>>> you've seen the type. He's gone, but I've not forgotten.
>>> Here's what I have. The database has 2 schemas: plant and test, each
>>> in it's own tablespace. The DBA modified my full backups to do an O/S
>>> level backup of the system files and plant tablespace. The database is
>>> shutdown, so it's a cold backup.
>>> We had a crash and I restored the database backup - that is the system
>>> files and plant schema tablespace file. Now, when I attempt to start
>>> the database I get a file corruption notice from the test schema
>>> tablespace files.
>>> I don't want to spend much time relearning Oracle, so I was hoping I
>>> could just drop the test schema, or force it open.
>> Is the data important?
>> 1) Backup
>> 2) Startup mount
>> 3) Drop tablespace test
>> 4) Alter database open
>> 5) Hire DBA
>> Palooka
>3) Drop tablespace test including contents;
 Tried 2-4 Database not open error. I did FRFM for a couple hours. As to 5:
Q: how many Indians IT personnel does it take to change a light bulb? A: one less than it takes to replace your pay grade.

Unfortunately, this is a system I DBA'd this app in 2000. I forgot most everything I learned, and this is a problem I've never encountered. Meanwhile, this creepy guy admined the system and changed everything with no doc... So, the backup script restores only the production schema and not the test schema and I get this error.

I'm just about to start editing the V$DATAFILE table to remove the test schema files.  

Thanks for your valiant attempts,
Julie Received on Sun Jul 12 2009 - 21:21:59 CDT

Original text of this message