4 Replies Latest reply on Oct 30, 2012 10:28 AM by 971394

    what happen during shutdown database

      Dear All,

      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 .