Re: URGENT: ORA-01554 upon startup

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 19 Mar 2003 15:28:51 GMT
Message-ID: <3e788b8b.1981944635@nyc.news.speakeasy.net>

On 18 Mar 2003 17:25:19 -0800, joel-garry_at_home.com (Joel Garry) wrote:

>Is there a reason you can't recover the db until the sequence before
>the one that crashed?

heh.. backups are only exports.. our hardware design calls for no data loss (mirrors, dual controllers, dual paths to drives, etc, etc). We didn't anticipate a database not to open. this is only a second data loss we've had in 4 years (first was due to a serious hardware failure, veritas failing to recover, and not having the knowledge in house how to rebuild VM volumes manually).

We were able to recover some of the data from application logs, but this was still very painful, the data was fairly valuable. Fortunately, we had some redundant data in another db, and were able to identify users affected.

Anyway, time to take a second look at our backup strategy. .......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Mar 19 2003 - 09:28:51 CST