Re: Using Shutdown Immediate

In article <40qts0$7gt_at_inet-nntp-gw-1.us.oracle.com>

           tkyte_at_us.oracle.com "Thomas J Kyte" writes:

: The next startup of the database might require instance
: recovery (which is automatically performed by ORACLE).
: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
: (this is the REALLY important statement for shutdown immediate.
: It implies that: dbwr is NOT given the chance to flush all dirty
: blocks from the buffer cache and: the blocks that are not flushed
: must be ROLLED FORWARD (not back) from the redo logs. If you do
: a full backup now, you will back up inconsistent tablespaces
: that need recovery, hence you will not have a real backup!)
:

On tbe other hand, quoting the same release of manuals (I think) the Concepts Manual p23-10 says:

"If the database administrator shuts down an instance (NORMAL or IMMEDIATE), ORACLE forces a database checkpoint to complete before the instance is shut down."

-- 
Jonathan Lewis