Database Shutdown

Database Shutdown

Different Modes in Database Shutdown

There are different modes to bring down the database:
1. Shutdown immediate
2. Shutdown transactional
3. Shutdown normal
4. Shutdown abort

Shutdown Immediate

1) No new connections are allowed.

2) Active transactions are terminated and uncommitted changes are rolled back.

3) Changes made by an active transaction are lost in this option.

$ sqlplus / as sysdba

SQL> shutdown immediate;

Shutdown Transactional

1) No new connections are allowed.

2) Oracle waits until all active transactions are completed.

3) Oracle then performs a checkpoint and then close the online data files.

$ sqlplus / as sysdba

SQL> shutdown transactional

Shutdown Normal

1) The database waits for all connected users to disconnect before shutting down.

2) It waits till all the current transactions end.

3) Oracle then performs a checkpoint and then close the online data files.

$ sqlplus / as sysdba

SQL> shutdown normal.

Shutdown Abort

1) Oracle closes the data files without any checkpoint.

2) This is the fastest shutdown mode.

Note-

 1) This happens immediately however the database is not shutdown cleanly.

 2) Database will have to perform instance recovery next time it is started.

3) This option should not be used in regular activities.