Re: HELP - URGENT : Newbie and crash

Export your data using the exporter from within Oracle and import it to the new database. Any good data will be preserved. Do a find for an executable named exp*

Oracle uses control files that do things like verify data file headers, etc. You cannot reuse the files from the old database.

Good Luck,
Chris Weiss

Marc Ledauphin <mledauph_at_club-internet.fr> wrote in message news:37B42FD0.76BAE2DD_at_club-internet.fr...
> I'm newbie in Oracle, so it's a great problem to me. Any help are
> welcome:
>
> I've a very important database running on SCO (Oracle 7). This good SCO
> host gave me a kernel pannic error!
> After rebooting the host, I've tried to start the data base, I've got
> the message : database mounted and nothing else...
> After a look in the alert.log, I saw that an ORA-600 message with
> argument [4195]
> My database is build with :
> data.dbf (All my datas)
> index.dbf (guess ?)
> base.dbf
> +
> roll, temp.dbf
>
> After analys the base.dbf is not consistent, but data and index are OK
> I tried recover database until cancel but it didn't work
>
> So, I create a new data base (the same script than the corrupted db) and
>
> I've copied the data and index files on to it.
> When I open the new database, oracle answers that data and index don't
> belong to this database.
>
> My question:
> Is there any way to retrieve my data? (like an export or something else
> ...)
>
> I've a too old backup, and the recents backup are not useable :-((
>
> Any suggestion, or advice are welcome
>
> M. Ledauphin
>
> mledauph_at_club-internet.fr
>
Received on Fri Aug 13 1999 - 10:15:34 CDT