Re: HELP - corrupted test scheme - V 8.05
From: Palooka <nobody_at_nowhere.com>
Date: Sun, 12 Jul 2009 23:34:15 +0100
Message-ID: <Hxt6m.60534$c71.59139_at_newsfe15.ams2>
Palooka 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.
>>
Date: Sun, 12 Jul 2009 23:34:15 +0100
Message-ID: <Hxt6m.60534$c71.59139_at_newsfe15.ams2>
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; Received on Sun Jul 12 2009 - 17:34:15 CDT