Re: HELP - corrupted test scheme - V 8.05

From: Palooka <>
Date: Sun, 12 Jul 2009 23:30:59 +0100
Message-ID: <Eut6m.60448$c71.20880_at_newsfe15.ams2>

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 Received on Sun Jul 12 2009 - 17:30:59 CDT

Original text of this message