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

Alert me