April 2000
Intermediate to advanced
94 pages
1h 52m
English
SHUTDOWN
SHUTDOWN
[NORMAL | IMMEDIATE | TRANSACTIONAL | ABORT]The SHUTDOWN command allows you to stop an Oracle instance. In order to use SHUTDOWN, you must be connected as SYSDBA, SYSOPER, or INTERNAL. For example:
SHUTDOWN SHUTDOWN IMMEDIATE
Oracle waits for all users to voluntarily disconnect before shutting down the instance. This is the default.
Oracle summarily disconnects each user as soon as his current SQL statement completes. Open transactions are rolled back.
Oracle waits for each user to complete his current transaction and then disconnects him.
All background processes for the instance are immediately aborted. Crash recovery will occur the next time the database is open, or if Oracle Parallel Server is being used, one of the surviving instances will recover the one that was aborted.