daily shutdown oracle application server...

[sarfraz Khan_2]

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...

[Steven Schweda]

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]

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.

[Patrick Wallek]

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.