Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is my database OK?
"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? Received on Fri Jun 24 2005 - 14:22:34 CDT