Different ways to Shutdown an Oracle Database #oracledatabase

Different ways to shutdown Oracle Database.

Shutdown Procedure
Oracle has three shutdown modes namely normal, immediate, and abort.

1. Shutdown normal:
This is the default mode of shutting down the database. During this state, the oracle server waits for all the users to disconnect.

2. Shutdown Transactional:
Waits until all the transactions are completed and then shuts down the database. During this state, no new connections are permitted.

3. Shutdown immediate:
This option will disconnect all the sessions; roll back all the running transactions and shut down the database. During the next startup, no instance recovery is needed.

4. Shutdown abort:
This option doesn’t roll back any transactions and simply brings down the database. In layman’s terms, it is just like pulling the power plug of the television. Any subsequent database startup needs an instance recovery to be initiated by smon.

Any backup taken after shutting down the database in abort mode will not be consistent. It is recommended to use the first three methods to shut down the database for a consistent backup.

Happy Learning!
God bless us all!