Re: Shutdown Abort Damages Database!

Dan, thats just the mentality of windows users, reboot fixes everything.  The only time i have to reboot my unix boxes is when changing hardware or upgrading the OS, its not the 'normal' way to fix things on the *nix operating systems.

Joe

Straub, Dan wrote:

> >
> > oracle>uptime
> > 10:47AM up 157 days, 8:04, 3 users, load average: 1.30,
> 1.18, 0.83
> >
> > 157 days up and you want me to reboot! Never.
> >
>
> I not sure why there seems to be this macho thing about how long your
> system has been up without a reboot. In my experience, ANY system
> should be rebooted at least once a month just to 'clean things up'.
>
> Day before yesterday, I had a problem on one of our in-house
> development systems where a log switch would hang because a checkpoint
> had not finished with the previous logs (they were still ACTIVE).
> Sometimes an 'alter system checkpoint' would take care of them,
> sometimes not. If it did work, it would only do log switches until all
> were either ACTIVE or CURRENT again. Tried restarting the instance a
> couple of times. Still no go. I was getting ready to just completely
> drop the db (assuming that I had a corrupt redo log or somesuch) and
> restore from previous nights export, but decided to check the other
> instances on the box to see if they were having the same problem. Sure
> enough, they were.
>
> Reboot cleaned it all up. No restore necessary. I suppose that if I
> was a unix SA, I may have delved more into the unix side of things to
> try and find out what went wrong....
>
> Regards,
> Dan Straub
> McKesson Information Solutions
> 541-681-8278
> 44°03'N 123°05'W (or thereabouts)
> Confidentiality Notice: This e-mail message, including any
> attachments, is for the sole use of the intended recipient(s) and may
> contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not
> the intended recipient, please contact the sender by reply e-mail and
> destroy all copies of the original message.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).