How to close oracle database

Method: 1. Use the "shutdown normal" command to shut down the database normally; 2. Use the "shutdown immediate" command to perform some cleanup work before closing the database; 3. Use the "shutdown abort" command to directly shut down the database. The session will be terminated.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to shut down the oracle database

1. shutdown normal

Close the database in the normal way.

2. Shutdown immediate

Shut down the database immediately.

When executing shutdown immediate in SVRMGRL, the database is not shut down immediately.

Instead, it is shut down after Oracle performs some cleanup work (terminating the session and releasing session resources).

When shutdown cannot be used to close the database, shutdown immediate can complete the database shutdown operation.

3. Shutdown abort

Directly close the database, and the session accessing the database will be terminated suddenly.

If there are a large number of operations being executed in the database , after executing shutdown abort, it will take a long time to restart the database.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to close oracle database. For more information, please follow other related articles on the PHP Chinese website!