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 -> DB recovery after OS crash, ORA-01210, ORA-01251

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

From: Stefan Burger <s_burger_at_t-online.de>
Date: Mon, 22 Sep 2003 20:44:15 +0200
Message-ID: <bknfu0$djo$03$1@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 Received on Mon Sep 22 2003 - 13:44:15 CDT

Original text of this message

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