RE: Question on starting up Oracle with "startup force"

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 27 Jul 2006 10:52:16 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0038A72B6@usa0300ms03.na.xerox.net>

Dennis,
The situation that I am experiencing is different from what you have described below. I am simply testing the startup and shutdown of the instance by off-lining and on-lining the database resource and I am not switching or failing over the instance between machines. In the current 3.5 version of DBE/AC, this works fine and as expected where upon on-lining the resource, the agent issues "startup" command. But in the SF 4.1, the agent is issuing the "startup force" command. What you have described below works when the agent issues a "shutdown immediate" command and the instance does not come down within a certain time period of time, which by default is 5 minutes. In this scenario, the agent will issue "shutdown abort" command to bring down the instance.  

Amir

---

	From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] 
	Sent: Thursday, July 27, 2006 10:35 AM
	To: Hameed, Amir
	Cc: oracle-l_at_freelists.org
	Subject: Re: Question on starting up Oracle with "startup force"
	
	
	Amir
	
	Startup force is a shorthand method of issuing:
	      shutdown abort
	      startup 
	(per

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:13094 02207602)          

        When you are implementing VCS, you are indicating that you want uptime. You don't want an interminable wait while Oracle tidies stuff up. You want it to come down immediately on the current server, and then be available as quickly as possible on the other server. This will allow the other applications that rely on Oracle to become available again in the shortest possible time.

            As far as shutdown abort, this issue has been discussed many times on this list and the answer has always been that it is safe in the current versions of Oracle. Yes, a novice DBA should not use it before doing a cold backup (you need to do a startup followed by a more normal shutdown), but that is not the situation with VCS switching Oracle to another server in your cluster.          

        Dennis Williams

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 27 2006 - 09:52:16 CDT