RE: Shutdown Abort Damages Database!

>
> 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: Straub, Dan
  INET: Dan.Straub_at_McKesson.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).