General
cancel
Showing results for 
Search instead for 
Did you mean: 

daily shutdown oracle application server...

sarfraz Khan_2
Occasional Advisor

daily shutdown oracle application server...

Hi,

due to some power supply problem, management wants to shutdwon oracle application and database server daily in evening and start in next morning.

is there any harm in applying daily shutdown policy in routine...
sarfraz khan
3 REPLIES
Steven Schweda
Honored Contributor

Re: daily shutdown oracle application server...

Cycling the power is often more stressful
for the hardware than keeping it powered on
constantly, so I'd guess that cycling the
power daily is not something most people
would recommend. However, if you know that
the power will fail every night, then it
would probably be better to do a controlled
shutdown every day than to let the power
company do an abrupt shutdown every night.

A smarter method would probably be to get
some kind of UPS (or similar power
conditioning equipment) on your important
hardware. That way, if the power stays on,
then your equipment should stay happy, and if
the power fails, then the UPS should be able
to keep things working long enough for a
controlled (automatic) shutdown. (And a UPS
should let you keep working through a short
(transient) power interruption.)

Around here, power is pretty reliable, and I
don't need to keep my stuff running 100% of
the time, so I know nothing, but if your
power is getting interrupted frequently, I'd
guess that its quality may not be too good
when it is on, and some UPS equipment can
help with power quality, too.
Ben Dehner
Trusted Contributor

Re: daily shutdown oracle application server...

From a database side, it's better to do a clean shutdown, even an abrupt one like 'shutdown abort', then just shutting off the system. The latter risks corrupting the data files, which is a Bad Thing. Depending on your particular applications, they may have open files and the like that don't take kindly to power failure.

Another factor to consider, what about off-hours processing? This may include batch processing as well as backups.
Trust me, I know what I'm doing
Patrick Wallek
Honored Contributor

Re: daily shutdown oracle application server...

I agree with the posts above. Doing a clean shutdown is definitely more desirable than allowing power to get cut. At least with a clean shutdown you are relatively certain that your DB was stopped cleanly and everything should be in a consistent state.