Re: Urgent, Urgent > Oracle 7.1.3 on Novell with incorrect Headers

From: Svein Erik Brostigen <svein.brostigen_at_oracle.com>
Date: Wed, 13 Mar 2002 21:40:00 -0500
Message-ID: <pan.2002.03.13.21.39.55.281352.28716@oracle.com>

On Wed, 13 Mar 2002 06:58:16 -0500, koert54 wrote:

> you could try the following :
> 
> 1. add _allow_resetlogs_corruption=TRUE in init.ora 2. startup mount 3.
> recover database until cancel
> 4. cancel  -> (fake the recovery)
> 5. alter database open resetlogs

Remember that if you choose to open a database with _allow_resetlogs_corruption, you MUST rebuild the database. This corrupts the data dictionary.
So the next steps should be:
6. exp system/manager file=... full=y
7. shutdown
8 Remove the database
9. Recreate the database
10. imp system/manager file=... full=y

Unless you do this, you will work with a corrupt database.

> 
> If this doesn't work you need to contact Oracle support and ask for DUL
> (data unloader)
> 
> "Peter Gehle" <info_at_sbg-it-systeme.de> wrote in message
> news:a6kl89$me4$06$1_at_news.t-online.com...

>> Hi,
>>
>> due of an Harddisk Crash we have an corruption of some file in the
>> SYSTEM and SADATA directory.
>> The message after Startup of the Database is : Incorrect Header in file
>> sys01.dbf
>> The second problem is, that the f****** Backup Software he done the
>> Daily Backup correctly, but he does'nt. So the latest availables Files
>> are from 6 month ago :-(( What kind of possibilities i got to recover
>> the damaged files ? Thera are any tools or function to dump the
>> Informations who are not

> damaged

>> in that files into an Dumpfile ??
>>
>> Thanx for helping
>>
>>
>>
>>
>>

Erik Received on Wed Mar 13 2002 - 20:40:00 CST