Re: impact of power outage on Oracle

Thanks all for the replies!

So far it appears everything is in order.

David

In article <iWqY5.1640$Fc2.168156_at_nnrp1.sbc.net>,   "Spencer" <spencerp_at_swbell.net> wrote:
> 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.
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 11 2000 - 10:00:20 CST