Re: Query Database while shutdown in progress

I dont think a startup force is a good idea. Last time I checked that did a shutdown abort followed by a startup.

On 6/27/07, Jared Still <jkstill_at_gmail.com> wrote:
>
>
> On 6/26/07, Sinardy Xing <oracle.rdbms_at_gmail.com> wrote:
> >
> > Hi all,
> >
> > When we shutdown Oracle instance with shutdown immediate mode. The
> > Oracle will wait until all rollback completed.
> >
> > The challenge is, how we can login to the instance to check the progress
> > of rolling back, assume we are given sysdba privilege.
> >
> >
> You could always do a startup force.
>
> This is the same (I think it is anyway) as a shutdown abort/startup.
>
> The difference is that the rollback takes place in the background after
> the database has opened.
>
> Long ago this was somewhat problematic as the rollback would be
> serialized.
> eg. if your rollback would have been in parallel normally, the startup
> force method would
> cause the rollback to be done in a single process, taking much longer to
> complete.
>
> I haven't looked at that in some time, so I don't know how it behaves now.
> If might be worth
> some reading and experimentation.
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l