Three Common shutdown methods in Oracle databases

The following articles mainly introduce several common methods for disabling Oracle databases. This article provides three common methods for disabling Oracle databases, of course, these three common close methods often appear in the actual use of Oracle, if you are a popular Oracle. The following article will be meaningful to you.

There are several common methods for disabling Oracle databases:

1,

 
 


  
  
Shutdown normal

 
 

Close the Oracle database normally.

2,

 
 


  
  
Shutdown immediate

 
 

Close the database immediately.

Run shutdown immediate in SVRMGRL, and the database is not closed immediately,

However, after Oracle executes some cleanup tasks, it closes session termination and releases session resources ),

When you use shutdown to close a database, shutdown immediate can be used to close the database.

3,

 
 


  
  
Shutdown abort

 
 

Directly shut down the database, and the session accessing the database will be suddenly terminated,

If a large number of operations are being performed in the database, it takes a long time to restart the Oracle database after the shutdown abort command is executed.