Home » RDBMS Server » Server Administration » Startup force and shutdown abort (General doubt)
Startup force and shutdown abort [message #631937] Thu, 22 January 2015 02:11 Go to next message
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 #631938 is a reply to message #631937] Thu, 22 January 2015 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Never use 1.
2. is not equivalent to 1.

Define "best". Best for what?

How is this a Forms question?

Re: Startup force and shu bort [message #631939 is a reply to message #631937] Thu, 22 January 2015 02:25 Go to previous messageGo to next message
John Watson
Messages: 7608
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 #631940 is a reply to message #631938] Thu, 22 January 2015 02:29 Go to previous messageGo to next message
gazzag
Messages: 985
Registered: November 2010
Location: Bristol, UK
Senior Member
Isn't "STARTUP FORCE" shorthand for:

SQL> SHUTDOWN ABORT;
SQL> STARTUP;
?
Re: Startup force and shu bort [message #631943 is a reply to message #631939] Thu, 22 January 2015 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

John Watson wrote on Thu, 22 January 2015 09:25
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.


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

Re: Startup force and shu bort [message #631992 is a reply to message #631943] Thu, 22 January 2015 23:52 Go to previous message
royalyogi
Messages: 22
Registered: November 2013
Location: India
Junior Member

Thanks a lot guy to clearing my doubt.
Previous Topic: Slow databases on a Solaris server after flushing buffer cache of one database
Next Topic: Shutdown immediate hangs with message "WARNING: aiowait timed out x times"
Goto Forum:
  


Current Time: Mon Oct 15 20:58:19 CDT 2018