Here's my guess. For the case where the box is powered off before Oracle is
shut down, it is possible to have transactions still in the buffers and not yet
written. These are lost. For the case where you do a shutdown abort,
transactions in progress are terminated immediately therfore all the updates
needed to a variety of table to maintain data integrity may not be written. The
databse will be restartable but the data may be inconsistent. If you shut down
the database in an orderly manner, transactions complete and all buffers are
flushed.
Received on Mon Mar 02 1998 - 00:00:00 CST
