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

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 23 Sep 2003 19:57:33 +0200
Message-ID: <d921nvkrjsjivqcnadseqs7ml4bbahhgld@4ax.com>

On Tue, 23 Sep 2003 19:30:02 +0200, Stefan Burger <s_burger_at_t-online.de> wrote:

>as far as i know - please correct me if i'm wrong - you have to mount
>the database before you can apply the redo logs. at the moment the
>database starts (startup in svrmgr30) i get ora-01122, ora-01110 and
>ora-01251 in this order. so the verify on the data file delivers a
>negative result because of an unknown file-header.
>
>any ideas?
>
>regards,
>stefan

I think you are beyond recovering the original database. If you state you have only one application user, and you have an export of that user (though it may be old), I would proceed by creating a new database, create the application user and import your export.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 23 2003 - 12:57:33 CDT