Re: Periodic restart plusses and minuses?

Hans Forbrich wrote:

> Joel Garry wrote:
>
>> Hans Forbrich <news.hans_at_telus.net> wrote in message
>> news:<KDK8d.32806$N%.31956_at_edtnps84>...
>>> I'd been listening with a moderate amount of amusement, but it's now
>>> getting out of hand ... (9iR2 & W2K)
>>>
>>> One of the local DBAs has his heart set on nightly shutdowns to do cold
>>> backups. Another DBA wants to go for online backups. (Archive logging
>>> is up and active.)
>>>
>>> The debate has gone all over silly territory and back and is now at:
>>> "Shutting down the database will waste all the automatic tuning benefits
>>> achieved from the system finding stability in the cache, etc.. It can
>>> take hours, even months to get the system stable."
>>
>>
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/tools.htm#28104
>> might be an argument against shutting down, and for creating OMS. And
>> as long as you have that, you might as well have an RMAN catalog, and
>> all that other management stuff and modern features.
>>
>>>
>>> Does anyone have pointers to documents, white papers, books, web sites,
>>> metalink note, etc. that I can drop on their desks to move them off this
>>> 'shutdown detunes the database' discussion?
>>
>>
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96519/intro.htm#1005206
>> might shift the conversation over to "gee, I'd sure like to have these
>> features."
>> Like corrupt block detection, and
>>
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96519/glossary.htm#432645
>> avoiding fractured block issues while still being able to run
>> overnight/month-end reports or other things that a growing business
>> might run into.
>>
>>>
>>> Due to politics, I will not provide an opinion or even make a
>>> supportable
>>> statement in either direction. This needs to be an external (to me)
>>> reference, and preferrably not an unsupported anecdote.
>>>
>>> (Once they're over this, I hope the discussion can get back to a pure
>>> business benefits discussion!)
>>>
>>> Thanks in Advance for helping control the local noise pollution!
>>> /Hans
>>
>> I'm with Mark on the nightly RMANs and weekly cold's, it seems to
>> cover most situations.
>>
>> jg
>
> Thanks all. I got the diversion I needed to get them back on track.
>
> From Howard's response I realized the core was a 'tuning by ratios'
> discussion. I printed off some of the NG's thread around the 'value of
> ratio-based tuning' [ ;-Q ] from a few months ago. That diverted their
> attention and the discussion is now proceeding smoothly toward RMAN and
> nightly warms.
>
> /Hans

LOL!!! :-O
HJR Received on Thu Oct 07 2004 - 22:57:47 CDT