Re: impact of power outage on Oracle

From: Spencer <spencerp_at_swbell.net>
Date: Sat, 9 Dec 2000 08:01:11 -0600
Message-ID: <iWqY5.1640$Fc2.168156@nnrp1.sbc.net>

the Oracle database should be fine. oracle should be able to rollback all uncommitted transactions, and i'm assuming that this includes statements using the keywords 'nologging' or 'unrecoverable'. i'm just wondering if there is an issue with recovery of the specific objects affected by these statements.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:90rdfu$24d9c$2_at_ID-62141.news.dfncis.de...
> The guy who told you that doesn't know anything about Oracle. The redolog
> mechanism allows Oracle to do crash recovery. During crash recovery any
> uncommitted transaction will be rolled back, and any committed transaction
> will roll forward.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> <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 Sat Dec 09 2000 - 08:01:11 CST