Home » RDBMS Server » Server Administration » Oracle Shutdown (9i,10g,11g)
Oracle Shutdown [message #406186] Tue, 02 June 2009 14:03 Go to next message
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 ?
Re: Oracle Shutdown [message #406192 is a reply to message #406186] Tue, 02 June 2009 14:36 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
I start with
shutdown immediate
& if/when that does not work I do
shutdown abort
Re: Oracle Shutdown [message #406195 is a reply to message #406186] Tue, 02 June 2009 14:44 Go to previous messageGo to next message
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?
Re: Oracle Shutdown [message #406196 is a reply to message #406186] Tue, 02 June 2009 14:51 Go to previous messageGo to next message
BlackSwan
Messages: 25032
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.
Re: Oracle Shutdown [message #406201 is a reply to message #406186] Tue, 02 June 2009 15:17 Go to previous messageGo to next message
prax_14
Messages: 64
Registered: July 2008
Member
Thank you very much for your replies.
Re: Oracle Shutdown [message #408046 is a reply to message #406186] Sat, 13 June 2009 05:27 Go to previous message
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:
  


Current Time: Fri Dec 02 12:21:06 CST 2016

Total time taken to generate the page: 0.08188 seconds