Re: Fourth shutdown option

Thanks,

    We'd found the reference you mentioned. There is also a very limited set on Metalink. And OEM is how we first found out about this option. I'm still curious as to why this shutdown transactional is never mentioned along with shutdown normal, shutdown immediate and shutdown abort. That includes third-party books as well as Oracle documentation. Also, I'd still like to know specifically how we set the timing.

Van

<speedrazer_at_usa.net> wrote in message
news:ep4svskibpo6gunvk25akiafood2g0efpp_at_4ax.com...
> 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 - 20:26:25 CST