Re: Is my database OK?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:haoob11mp3aeu82nodg7f8u3gqgqh6rsuj_at_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

I know the database opened ok, but you might want to check for block corruption. If there was a fire, sudden power loss and physical damage, could there be a potential for hard disk damage as well? If your disk array, or wherever you're storing your datafiles, doesn't have it's own battery backup, bad things can happen to your datafiles.

Use:
ANALYZE (TABLE | INDEX | CLUSTER) table_name VALIDATE STRUCTURE; /* Etc... */

Oracle won't tell you there's block corruption till you try to read from that block.
Do this when database activity is at a minimum because this procedure can be very time consuming.

For more information reference the ANALYZE sql statement documentation. To learn how to fix block corruption, reference RMAN.

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup