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

From: Stefan Burger <s_burger_at_t-online.de>
Date: Tue, 23 Sep 2003 17:50:08 +0200
Message-ID: <bkpq3i$tof$05$1@news.t-online.com>

hi Paul,
its the tablespace of one user, containing only this one users data. our   client application works this way to create a user, tablespace and a datafile with the same name.
the last backup is an export of the users data, some months old.

I dont think I can recover the database this way...

thanx,
stefan

Paul Drake wrote:

> 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 Tue Sep 23 2003 - 10:50:08 CDT