weekend database and server shutdown
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: weekend database and server shutdown

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    weekend database and server shutdown

    Hi,

    DB Ora 8i/ora9i/10g on AIX
    Apps on windows 2000 server

    Our database and apps runs or are being used only during weekdays.
    We do full backup every fridays.

    My question is, Is it ok to shutdown the servers during weekends?
    Some said that its better to leave the server running 24hrs than do
    frequent shutdowns, Is this true?

    Thanks a lot

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Yes its better to leave the server like that.The simple reason is your SGA which is warmed up if you recycle it oevr weekends the SGA has to be warmed up aagin with sql statements parse plans etc..

    so if you dont have a strong valid reason dont do this.

    regards
    Hrishy

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks,

    But if performance is not an issue, and hardware life expectancy is.
    Will our servers last longer if i make them rest during weekends?

    Thanks

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi don't know about the other guys, but I tend to find most problems occur during reboots, not before or after.

    It's getting a "rest" if people aren't using it
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You will most likely exhaust the capacity of your systems before you wear them out. Why worry about it?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    I would look into re-booting the windoze box, I have yet to meet a windoze box that does not get weird after being up for more that (48 hours) some time.

    We re-boot all Unix boxes here weekly, why? I have no idea.
    I remember when this place was cool.

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    I just e-mailed the Unix admins out of pure curiosity, now I have to know why this is the policy here.
    I remember when this place was cool.

  8. #8
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Electronic components are happiest in a constant state, i.e, ON

    Turning off/on the servers increases the risk of component failure during state change.

    Leave 'em on. Unless of course, it's your turn on the treadmill =]

  9. #9
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Quote Originally Posted by Mr.Hanky
    I just e-mailed the Unix admins out of pure curiosity, now I have to know why this is the policy here.
    There was a an oracle bug at one time a few years back, that related to how long the server had been up - number of clock ticks since king tut built his first piramid or something.
    We had an aix machine that was up for almost 3 years. The concern was that the platters wouldn't start spinning again when it was finally rebooted! Came up fine.

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    Haven't heard from them yet, probably took the day off for a long weekend.
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width