i have a questions and i enclosed some suggestions for the answer because I'm confused about the answers :
What happens during shutdown oracle database :
and the suggested answer :
1- When shutdown the database with NORMAL or IMMEDIATE option : the database system writes check point before shutting down the database .
2- when you shutdown the database with the IMMEDIATE , option , open transaction are rolled back before the database is shutdown .
3- shutting down the database with abort always requires an instance recovery at the next startup .
please suggest the right answer .
First of all shutdown has 4 options
Default is normal
Normal: No new connections are allowed. Database and redo buffers are written into disk.Database is closed.
Backgroud process are terminated.SGA is deallocated. Until and unless all users disconnect, database wont be closed.
Transactional: No client can start a new transaction. Clients get disconnected once their transactions are completed.
Database and redo buffers are written into disk.Database is closed.Backgroud process are terminated.SGA is deallocated.
Immediate: Current running SQL are not completed. Oracle does not wait for users to disconnect.
All active transactions are rolled back.Database and redo buffers are written into disk.
Database is closed.Backgroud process are terminated.SGA is deallocated.
Abort: All users are disconnected.Database and redo buffers are NOT written into disk.
All background processes are killed instantly and instance is abruptly terminated.