What are the different methods of shutdown our database?
@ : Home >
> Interview Room
- SHUTDOWN (or) SHUTDOWN NORMAL-No new connections are accepted and wait for the user to close the session.
- SHUTDOWN TRANSACTIONAL-No new connections are accepted and wait for the existing transactions to commit and logouts the session without the permission of user.
- SHUTDOWN IMMEDIATE-No new connections are accepted and all committed transactions are reflected in database and all the transactions are about to commit are rolled back to previous value.
- SHUTDOWN ABORT-It’s just like an immediate power off for a database, it doesn’t mind what are the transactions running it just stops entire activity -(even committed transactions are not reflected in database) and make database unavailable. SMON process takes responsibility for recovery during next startup of database