Re: What is Oracle doing during statup?

Oracle does not perform an instance recovery when a shutdown immediate was previously given.
An instance recovery implies replaying the transactions since the last checkpoint
from redologs .
All shutdown options (normal, immediate, transactional) - except 'abort' - perform a checkpoint
when shutting down the database so there's no need for instance recovery when starting up.

Most probably in your case the database was given a shutdown abort and at the first
startup an instance recovery will occur ... resulting in replaying redo, rebuilding buffercache,
rollbacking unfinished transactions etc ...

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3c8f423f$0$230$ed9e5944_at_reading.news.pipex.net...
> If it was shutdown abort or immediate it is performing recovery.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Graeme Barnett" <gbarnett_at_csl.co.uk> wrote in message
> news:47120ba9.0203130401.31cb1697_at_posting.google.com...
> > Can anyone tell me what Oracle does when it starts up?
> >
> > I'm particularly asking as I want to know why Oracle 8 on Solaris is
> > taking around 10 minutes just to start the instance I've just
> > extracted from a customers backup tape.
> >
> >
> > Regards,
> >
> > Graeme
>
>
Received on Wed Mar 13 2002 - 06:20:46 CST