1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Shutdown Immediate DB

Discussion in 'Server Administration and Options' started by tomloera, Feb 17, 2011.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Good Moorning Friends;

    Question, Is possible lost information if we make a shutdown immediate db?

    It is recommended to abort all connections to the database and to make a backup?

    Thanks fo your help
    Regards
    Tom
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Shutting down immediate will roll back all the uncommitted transaction. But once committed will not be lost.

    The most popularly used method is to shut down db with immediate option which terminates all sessions and does a rollback on all uncommitted transactions.
     
  3. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Raj

    Thanks a lot of your help
    Regards