Re: impact of power outage on Oracle

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Fri, 8 Dec 2000 11:12:50 -0600
Message-ID: <90r4oa$n7s$1@news.gte.com>

You should be fine as long as you are using either raw devices or journaled filesystems for your data files AND you don't rely on write cache RAID storage or something like that.

At any rate, when I want to verify things I do a direct=y, full=y exp to /dev/null. If you have bad table blocks, they will show up here. Doing this will not check your index blocks, but you can always rebuild an index if you find one corrupted later.

-Kevin
<dtaylor3984_at_my-deja.com> wrote in message news:90r1f8$mft$1_at_nnrp1.deja.com...
> Hi all, we just had a power outage yesterday and the Oracle server on
> AIX had a 'cold' shutdown. We are new to Oracle and have heard that
> Oracle doesn't take cold shutdown very well. Is it possible that any
> data file might be damaged and problem may surface days from now?
> Is there any utitility or tool that we can use to check the integrity
> of Oracle database?
>
> Thanks!
>
> David
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 08 2000 - 11:12:50 CST