RE: Planned Maintenance - Believe or not ?
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <sreejithsna@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 22 Jun 2012 12:56:11 -0400
I run single instances, for quite awhile, and with several companies and OS's.
For oracle databases, my analogy is that it should be treated like a fighter
jet plane. These planes are built to run 24hours/day and operate better that
way. They actually require more or completely different maintenance
schedule(s) depending on how long they stay idle.
Analogously, oracle doesn't like to span startups, with things like historical
reports (Ent mgr), v$ views, and just the extra warm up that happens upon start
up to mention some. They do get shutdown once in a while for maintenance
reasons, but no schedule.
In the old days, rebooting was done for various reasons. Back in the early
90's, on HP, and Dell, the sysadmins wanted a reboot
'the server' on Sunday night believe it or not, (thus the databases went with
that). Even running on windows I did not have a scheduled reboot.
Having said that, some people 'keep' a scheduled window for rebooting for ease
of administration, (whether for the app or server, or database) -- they always
have a window for maintenance and therefore scheduling the maintenance is
easier.
Now applications that run in windows boxes sometimes need it, especially with
mistakes like memory leaks and the like.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sreejith S Nair
Sent: Friday, June 22, 2012 12:34 PM
To: Oracle - L
Subject: Planned Maintenance - Believe or not ?
Hi friends,
The question is about the planned maintenance activities you do on a server
level or database level. The activity I am referring to is rebooting the node
and restarting database instances , crs stack etc. we had this routine from
sometime back, but now management asks why should we do it. I have heard from
many people that they usually do a server reboot when the uptime goes more than
6 months or so. Now,the management is saying why we have to do it. The plain
explanation is that a software is designed to run and to handle a load , then
it should run for ever if nothing on it is changed.
I would like to know whether any one has something like a planned maintenance
activity where you reboot servers and reboot instances every 6 months or so ?
Regards,
Sreejith
-- Sent from my iPhone
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
