Re: Fourth shutdown option

This is directly from the Oracle 8 Administrator's Guide:

When you wish to perform a planned shutdown of an instance while minimizing interruption to clients, you can use the SHUTDOWN command with the TRANSACTIONAL option:

SHUTDOWN TRANSACTIONAL; After submitting this statement, no client can start a new transaction on this particular instance. If a client attempts to start a new transaction, they are disconnected. After all transactions have either committed or aborted, any client still connected to the instance is disconnected. At this point, the instance shuts down just as it would when a SHUTDOWN IMMEDIATE statement is submitted.

A transactional shutdown prevents clients from losing work, and at the same time, does not require all users to log off.

From the Oracle Enterprise Manager Admin Guide 1.6:

Backup Manager: Operating System Backup Subsystem makes mention of the ability to give a timeout period for doing transactional shutdowns.

HTH,
SR

On Mon, 30 Oct 2000 23:54:37 GMT, "Van Messner" <vmessner_at_bestweb.net> wrote:

>In SQL*Plus you can issue a "shutdown transactional" command which seems to
>function halfway between "shutdown normal" and "shutdown immediate". There
>is very little documentation we can find, although it appears we should be
>able to set a time limit for pending transactions to complete. Oracle will
>attempt to complete transactions until the time limit is reached then switch
>to shutdown normal.
>
>Anyone know how we can set the time limit or have more information on
>shutdown transactional? Is it an argument? An init.ora parameter? Since
>this option has been around since Oracle 8, why does it never seem to be
>mentioned?
>
>Thanks,
>
>Van
>
Received on Mon Oct 30 2000 - 18:46:49 CST