Re: Using Shutdown Immediate

Nalini Vallampati <> wrote:
>>Thomas J Kyte writes:
>>
>>Please, after a shutdown immediate, do a startup followed by a clean shutdown
>>(with no options). It is definitely not guaranteed to work any other way.
>
>But if the 'shutdown immediate' rolls back the users' transactions before
>kicking them out, how would a startup and clean shutdown after shutdown
>immediate help from the point of view of point-in-time recovery ?
>Wouldn't the datafiles after the clean shutdown be in the same state they
>were after the immediate shutdown ? (i.e., with their consistency affected ?)

The transactions may be rolled back but that change isn't necessarily written to the datafiles. The rollback MAY have only been done incore and may only exist in the online logfile and need to be written on the next startup. A shutdown normal will ensure that a everything is flushed to the datafiles.

-- 
Regards, 

Lee E. Parsons                  		lparsons_at_world.std.com