Oracle Stop Procedure

Oracle Stop Procedure

1.Shutdown abort

2.Shutdown Immediate

3.Shutdown Transactional

4.Shutdown Normal

Shutdown Abort:

The Database is forcibly shut down and may not be consistent and requires recovery during startup. SMON Ensures that the database is  consistent.

Shutdown Immediate:

The Database is shutdown immediately, but all committed transactions are updated in the database and opened transactions are rolled back. No new connections are allowed.

It is Consistent

Shutdown Transactional:

The database does not allow any new connections, all the committed data is updated in the database and opened transactions are only allowed to complete, no new transactions are allowed.

It is Consistent

Shutdown normal:

It allows the users to complete all the transactions  and shutdown the database. No New connections are allowed but time consuming to stop the database. Existing users are allowed to complete the transactions.