Submitted by: sanjay
There are four types of shutdown
Shutdown Normal - Normal is the default mode, here new user can't logon to the database, but the current user can start the new transaction and work till he wants, the database shutdown only after the last user logs off.
Shutdown Transactional - here new user can't logon to the database, and the current user can't start the new transaction, once the current transaction complets, database shutdown.
Shutdown Immediate - here new user can't logon to the database, user can't start the new transaction, the current transactions rolls back, and database shutdown.
Shutdown Abort - here new user can't logon to the database, user can't start new transaction, the current transaction is not rolled back, database shutdown's.
While shutting down oracle updates data file header and control file with the current checkpoint informanation, Except Shutdown Abort the checkpoint is same in datafile header and control file it means database is consistance and it is clean shutdown. If the checkpoint is not same at both locations then instance recovery required at next startup.
I hope it will clear your doughts.
Above answer was rated as good by the following members:
contactspatel, rnraomaddula