Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent, Urgent > Oracle 7.1.3 on Novell with incorrect Headers

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

From: koert54 <koert54_at_nospam.com>
Date: Thu, 14 Mar 2002 18:09:27 GMT
Message-ID: <rH5k8.5552$DE4.815@afrodite.telenet-ops.be>


Sorry - that was so obvious to me I forgot to mention it ;-)

"Svein Erik Brostigen" <svein.brostigen_at_oracle.com> wrote in message news:pan.2002.03.13.21.39.55.281352.28716_at_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 Thu Mar 14 2002 - 12:09:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US