Re: Is my database OK?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 24 Jun 2005 21:40:14 +0200
Message-ID: <haoob11mp3aeu82nodg7f8u3gqgqh6rsuj@4ax.com>

On Fri, 24 Jun 2005 19:22:34 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>
>"Dave" <x_at_x.com> wrote in message
>news:aSYue.55850$G8.30078_at_text.news.blueyonder.co.uk...
>>
>> "Randy Harris" <randy_at_SpamFree.com> wrote in message
>> news:zLYue.3437$re.542_at_newssvr19.news.prodigy.com...
>> >I have a server running 8.1.7.4 on HP-UX that was brought down hard
>earlier
>> > today. There was an electrical fire and all power was cut abruptly
>> > (mains,
>> > UPS, everything).
>> >
>> > The system is now back up and the database seems to have recovered.
>What
>> > sorts of things should I be checking to help assure that all is OK?
>> >
>> > I can't find a log file. Is there a "default" location for a log that
>> > might
>> > have documented the recovery?
>> >
>> >
>>
>> the alert log in background_dump_dest
>>
>> if it opened then the database is a clean state. Your app might need
>> checking though
>>
>
>Thanks very much for pointing me to that alert log. I closely examined the
>section from today's events. It says that the "crash recovery completed
>successfully". Would you think that sufficient to be confident that the
>database is OK?

crash recovery including the subsequent 'database opened' message. If there are inconsistencies, the database definitely won't open.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jun 24 2005 - 14:40:14 CDT