That is true but, that is not really the area of "loss" I was referring to. Your point is valid but, those changes are not usually career altering if they are lost... 8-)
M
>>> "henry Wollman " <oracledba-ezmlmshield-x20516437.[Email address protected] 1/4/2006 2:54:32 PM >>>
One thing I can think of is parameters that are changed in memory only when
using an spfile. Or any parameter changed online, but not changed in the
pfile, if your are using a pfile..
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x52892903.[Email address protected]
Sent: Wednesday, January 04, 2006 1:42 PM
To: LazyDBA Discussion
Subject: RE: bouncing the db?
I'd like some example(s) of where rebooting the db will/could result in
"changes not recorded permanently and hence likely to be lost". If there is
such a thing, I better be getting my resume up to date...
M
>>> "Shergill Gurmohan " <oracledba-ezmlmshield-x92555731.[Email address
protected] 1/4/2006 2:23:25 PM >>>
I am not against bouncing databases and servers once in a while but I see
your point also that these should not have to be bounced if there are no
problems with them in the current time. This could be possible in a very
strictly controlled or more like ideal environments where everything that
goes wrong at any time is always trapped and corrected. In real life things
do happen to our systems which we don't fully comprehend or which we can't
get fixed right away but these things also don't affect us in big way and we
let them go by. Such things if let go too far are going to stop you at some
point of time definitely. My liking is that we should try to bounce our
systems if we can afford to do so and make sure that we are not too far from
a system that when shutdown would also come back up good.
On the other hand I want to draw attention to another fact that we shuld
also not forget to the probabilities of loosing changes that were done to
oracle databases on session or system level but not at database level. Such
changes are not recorded permanently and hence are likely to get lost with
the bouncing of the database. If such a thing will happen to me when I am
bouncing my databases once every month than when I do so once in a year or
two, the chances are that if some changes are lost I will be able to
remember them easier when the change was done not so long ago.
Anyway, it is your own liking. If you feel more comfortable not bouncing you
have a reason to not do so.
Before I forget, please let me wish all my collegues a Happy and Prosperous
Happy New Year from me.
Gurmohan
www.onlymath.com - Place to learn and teach math.
-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x96745458.[Email address protected]
Sent: Wednesday, January 04, 2006 2:08 PM
To: LazyDBA Discussion
Subject: RE: bouncing the db?
I can see SQLServer bouncing (windows :))
We also used to bounce DEC alpha 64 bit, and HP-UX Tru64 once per week
at old locations, (and sysadmins did like that -- actually they
instantiated the policy).
However, I don't really think that you should have to do that. Even on
Windows boxes we barely reboot ever here. Think of the 24/7 databases
out there, and especially RAC/GRID instances running 24/7. Sure there
you probably could reboot and keep the other instance up etc., but
something tells me you should not have to do this.
-----Original Message-----
From: Anthony Molinaro
[mailto:oracledba-ezmlmshield-x86509559.[Email address protected]
Sent: Wednesday, January 04, 2006 12:03 PM
To: LazyDBA Discussion
Subject: bouncing the db?
hello dba's,
I have a question that I am hoping you can help with.
We have different rdbms at my company and as expected
each one is treated differently.
from our experience (well, from the suggestion of sql server
consultants)
its good to bounce the sql server databases every so often.
now, I've never done this with oracle but I am wondering
if any of you have.
I am ofcourse aware of the various drawbacks to bouncing
the db (such as flushing the caches making all new sql hard parsed)
but it would be done at our maintenance window (so, no worries
about users and their sql).
over the last 6 months we've hit some bugs with oracle that neither
I nor oracle support have been able to really fix (we're talking
severity 1 tar here, so, very senior support analysts working with
me to resolve various problems as we got nowhere).
in some cases (magically) bouncing the db
(at the suggestion of support) has helped.
I'm not crazy about doing this all the time but if it saves me
from all-nighters and rebuilding production from standby via
failover (which is a total pain as our db's are ~1tb) then I'll do
it.
this would be a monthly thing or every other month.
so, we're talking 6 - 12 bounces a year.
any feedback (good or bad) would be appreciated.
thanks guys/gals,
Anthony
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page