OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Shutdown (9i,10g,11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Shutdown [message #406186]

Tue, 02 June 2009 14:03

prax_14
Messages: 64
Registered: July 2008

Member

What kind of oracle shutdown is done for the following
a) Restarting Operating System.
b) Restarting Oracle service in windows services panel.

shutdown abort or shutdown immediate or shutdown transactional or shutdown ?

Report message to a moderator

Re: Oracle Shutdown [message #406192 is a reply to message #406186]

Tue, 02 June 2009 14:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I start with
shutdown immediate
& if/when that does not work I do
shutdown abort

Report message to a moderator

Re: Oracle Shutdown [message #406195 is a reply to message #406186]

Tue, 02 June 2009 14:44

prax_14
Messages: 64
Registered: July 2008

Member

BlackSwan,

Thanks for your reply. I think i did not covey my question correctly, Sorry my bad.

My question is what will happen to the oracle instance running when I do the following ,

a) Restart the operating system.
b) Restarting Oracle service in windows services panel.

what kind of shutdown option it is equivalent to?

Report message to a moderator

Re: Oracle Shutdown [message #406196 is a reply to message #406186]

Tue, 02 June 2009 14:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Both cases are equivalent to shutdown abort; or simply unplugging the power cord.

shutdown abort is "safe" in that committed transaction are retained & uncommitted changes will be rolled back upon startup.

Report message to a moderator

Re: Oracle Shutdown [message #406201 is a reply to message #406186]

Tue, 02 June 2009 15:17

prax_14
Messages: 64
Registered: July 2008

Member

Thank you very much for your replies.

Report message to a moderator

Re: Oracle Shutdown [message #408046 is a reply to message #406186]

Sat, 13 June 2009 05:27

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

You can change the Shutdown mode of database when you use Windows Service to stop the database

For more information, please refer:
http://download.oracle.com/docs/html/B13831_01/admin.htm#i1006074

Additionaly, here you can find more interesting details

[Updated on: Sat, 13 June 2009 05:29]

Report message to a moderator

Previous Topic:	Ora-03113 End of file on communication channel
Next Topic:	Manual deleting Archived Log files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 22:20:41 CDT 2024