Re: Bring Online down in middle of transaction rollback?

In article <345FF276.8D170CD2@echonyc.com>, Cosmo Lee <"* N O - S P A M * cosmo"@echonyc.com> writes >If I did this, would the recovery process have to complete the rollback of the >transaction before the DB came online? > Yes. So shutting down and starting up achieves nothing apart from making the restart take longer. >Art S. Kagel wrote: > >> If all else fails shutting down you should be OK. The startup recovery >> process will rollback the transaction correctly but it may not be much >> faster than waiting. The only risk is the logical and physical log >> buffers which are flushed to disk on a normal shutdown so you are safe. >> >> Art S. Kagel > > > >-- >* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * >ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. > >Cosmo Lee Multi-User Computer Systems Brooklyn, NY > > "JUST SAY 'NO' TO SPAM" >* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > > -- David Williams