This discussion is archived
4 Replies Latest reply: Oct 30, 2012 3:28 AM by 971394 RSS

what happen during shutdown database

743302 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points