Re: DB recovery after OS crash, ORA-01210, ORA-01251

Stefan Burger <s_burger_at_t-online.de> wrote in message news:<bknfu0$djo$03$1_at_news.t-online.com>...
> hi ng,
> after a security update of an NT4 oracle 8.0.6 server the os hang and
> did not start anymore. i was able to copy the complete database
> directory to a new machine, where i installed oracle in the same way it
> was installed on the old server and just copied the old files over the
> new database.
> now i get several error when starting the database like ORA-01251, there
> seems to be something wrong with the header of my datafiles. i tried to
> recreate the control files, but oracle is not accepting the datafiles
> from the old DB. dbverify discovered 1 (one) bad page.
>
> does anyone have an idea how to get the database up and running or how
> to extract the data out of the datafiles?
>
> ... of cause there is no backup from the db available.
>
> thanks in advance,
>
> stefan burger

Obtain a backup of the database files before going any further. Open a support issue (iTAR) with Oracle Support.

How important was the datafile that is listed as having this issue? If that data can be reloaded, or if the datafile is in a tablespace that contained only indexed and can be rebuilt, you may be willing to sacrifice that datafile (and its tablespace) in order to get the database opened.

Have you attempted recovery yet?
Do you have all of the online redo logs, controlfiles, archived redo logs?
What backup sets do you have? (you say 'no backup' above). Do you have an export? (dump file) (most likely no, see above).

If media recovery cannot recover the datafile, and if you have no means to recreate the data within that datafile, then the Oracle Data Unloader Utility may be your only recourse (although others have posted here that other utilities may be in development). Its very expensive. Again, contact Oracle Support.

> seems to be something wrong with the header of my datafiles.
Which datafile is it?
Is it a rollback segment or system tablespace's datafile?

good luck.
most likely there will be some options of getting a subset of the database open, which you can export and then import into a new database. it may take a few underscore parameters to pry it open corrupt (before rebuilding it) under Oracle Support's direction.

Pd Received on Mon Sep 22 2003 - 17:31:16 CDT