| Startup force and shutdown abort [message #631937] |
Thu, 22 January 2015 02:11  |
 |
royalyogi
Messages: 22
Registered: November 2013
Location: India
|
Junior Member |
|
|
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  |
John Watson
Messages: 8963
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 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
