Startup force and shutdown abort [message #631937] |
Thu, 22 January 2015 02:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8b6f19ef76b13b50b7a68d78372dd9c9?s=64&d=mm&r=g) |
royalyogi
Messages: 22 Registered: November 2013 Location: India
|
Junior Member |
![royalyogi](/forum/theme/orafaq/images/google.png)
|
|
hi team .
I have doubt on below two points
1. Startup force
2.) shu abort -> startup -> shu immediate -> startup
whats is difference on above two points and which is best option
Thanks in adavance
Yogesh
[EDITED by LF: modified topic title; was "Startup force and shu bort"]
[Updated on: Fri, 23 January 2015 00:08] by Moderator Report message to a moderator
|
|
|
|
Re: Startup force and shu bort [message #631939 is a reply to message #631937] |
Thu, 22 January 2015 02:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
STARTUP FORCE is exactly equivalent to SHU ABORT followed by STARTUP OPEN, it just saves you a few letters of typing. But do not belive me: look at the alert log to confirm this.
|
|
|
|
Re: Startup force and shu bort [message #631943 is a reply to message #631939] |
Thu, 22 January 2015 03:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
John Watson wrote on Thu, 22 January 2015 09:25STARTUP FORCE is exactly equivalent to SHU ABORT followed by STARTUP OPEN, it just saves you a few letters of typing. But do not belive me: look at the alert log to confirm this.
No exactly equivalent in old versions but maybe this has changed since.
Before, shared OS objects (memory, semaphores) were not (always or completely) released with STARTUP FORCE.
Starting with 10.2 (before FORCE was hidden) documentation mentioned "In unusual circumstances" for this command.
Also it is said (about John's alert.log remark):
Quote:If an instance is running, STARTUP FORCE shuts it down with mode ABORT before restarting it. In this case, beginning with Oracle Database 10g Release 2, the alert log shows the message "Shutting down instance (abort)" followed by "Starting ORACLE instance (normal)." (Earlier versions of the database showed only "Starting ORACLE instance (force)" in the alert log.)
So maybe it is now the same thing but I won't bet a dime on it and will recommend to not use it.
[Updated on: Thu, 22 January 2015 03:03] Report message to a moderator
|
|
|
|