Re: Periodic restart plusses and minuses?

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

--
@home.com is bogus.
A real Grundfest:  http://www.zdnet.com.au/news/business/0,39023166,39162206,00.htm