Re: system01.dbf corrupt, any chance of recovery?

From: TC <donotuse_at_donotuse.com>
Date: Mon, 24 Mar 2003 22:11:18 GMT
Message-ID: <aoLfa.220987$6b3.632717_at_rwcrnsc51.ops.asp.att.net>


Unfortunately, that cannot be done.

Since you do not have good backups, if you do not have exports, I think it is not possible for you to recover any data.

//tc

"Atif" <tuxman380_at_yahoo.com> wrote in message news:de0f683b.0303241031.5f245f50_at_posting.google.com...
> That is an option we are looking into right now. We do not have a support
> contract. So it is some time.
>
> I do have another question. If I can fully recover an older version of
 the
> system datafile, Can I combine it with the the current datafiles, recreate
 the
> control files using the new combo and expect to be able to get some data
 out of
> the non-system tables?
>
> -Atif
>
> > Only if you can afford to pay $$ to Oracle to bring in a consultant
> > with DUL (Data Unloader). But even if that case you still won't have
> > proper object names.
> >
> > A proper backup procedure also includes a weekly export.
> >
> > Regards
> >
> > Sybrand Bakker
> > Senior Oracle DBA
Received on Mon Mar 24 2003 - 23:11:18 CET

Original text of this message