Database Reference
In-Depth Information
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Immediate database shutdown disallows new connections. Active transactions are rolled
back, and all connected users are disconnected.
The next time you start up the database it will not require instance recovery.
SHUTDOWN TRANSACTIONAL
CDB Instance
SHUTDOWN TRANSACTIONAL
is a compromise between
SHUTDOWN NORMAL
and
IMMEDIATE
.
Use
SHUTDOWN TRANSACTIONAL
when you want to allow active transactions to complete prior
to taking the database down. When you issue the command, new connections and new
transactions are disallowed. As transactions complete, the associated client sessions are
disconnected:
After a transaction completes, if the client is still connected to the instance, it will be
disconnected.
■
After all transactions complete and sessions are disconnected, the database shutdown
will proceed.
■
If there are pending transactions in the
CDB$ROOT
container, the
SHUTDOWN
TRANSACTIONAL
command will wait until the transactions are committed
or rolled back, and then the shutdown will continue. Issuing the
SHUTDOWN
TRANSACTIONAL
command from the
CDB$ROOT
will roll back any pending
transactions in PDBs and discard any changes that are not committed.
A transactional shutdown prevents clients from losing work as they would during a
SHUTDOWN IMMEDIATE
but does not wait for users to disconnect as during a
SHUTDOWN NORMAL
.
The next time you start up the database it will not require instance recovery.
SHUTDOWN ABORT
CDB Instance
SHUTDOWN ABORT
brings the instance down immediately. The database is not closed and
it is not dismounted. This action is a controlled method to take the database offline, just
one step shy of killing the server processes, losing power, or otherwise crashing the server.
Perform a
SHUTDOWN ABORT
only in the following situations:
■
SHUTDOWN IMMEDIATE
did not work.
Instantaneous shutdown is required, for example, when you disconnect users immedi-
ately and recover the database.
■
There were problems when you tried to start up a database.
■
Search WWH ::
Custom Search