4 Replies Latest reply: Oct 30, 2012 5:28 AM by 971394 RSS

    what happen during shutdown database

    743302
      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 .

      Regards
      Anwar
        • 1. Re: what happen during shutdown database
          Vedant..
          First of all shutdown has 4 options
          1.Normal
          2.Immediate
          3.Transactional
          4.Abort

          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.
          • 2. Re: what happen during shutdown database
            743302
            Thanks Vedant
            • 3. Re: what happen during shutdown database
              Vedant..
              You are welcome..
              • 4. Re: what happen during shutdown database
                971394
                Thanks a lot.usefull post