Home>Article>Database> How to close oracle database

How to close oracle database

WBOY
WBOY Original
2022-01-25 11:42:38 19156browse

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.

How to close oracle database

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn