Just to add some controversary - I cannot think of a
single reason to bring a database down during normal
operation. To change some static parameters, or
upgrade it, then yes, but other than that - its just
shooting yourself in the foot.
When your database has been up for some time, its nice
and stable - all the queries have been parsed, your
buffer cache is perfectly primed, life is good - and
then bang - you shut the thing down and start from
scratch each day...Ugh!
My view is leave your database up unless you
absolutely, definitely need to bring it down...
Cheers
Connor
- Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote: >
Henry brings up a good point. Users accept
> scheduled downtime (cold backups), therefore it
> allows me perform system maintenance w/out asking
> for permission :) They always want 24x7 and never
> give permission.
>
> >>> Henry.Poras_at_ctp.com 10/04/01 05:55PM >>>
> And what about changes to the init.ora? No scheduled
> downtime is necessary
> with cold backups. (of course more stuff can be
> changed on line these days)
>
> Henry
>
> -----Original Message-----
> Sent: Thursday, October 04, 2001 5:11 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Well for 1 reason, Cold backups are restored using
> OS cmds, no need for
> Oracle recovery, whereas, Hot Backups require OS
> cmds + Oracle recovery.
> One exception is pt in time recoveries. I do have 1
> db that will be
> web-enabled, therefore 24x7. So guess what I have
> to do, Hot Backups. I am
> not against them, just prefer cold. Anyone have
> hot backup scripts? Lisa,
> you are the script ninja, got 1 of those scripts
> lying aorund. Thanks :)
>
> Gene
>
> >>> kimberly.smith_at_gmd.fujitsu.com 10/04/01 04:00PM
> >>>
> Why is better Gene? What is it about the files
> being closed
> that gives you the trust factor? I don't use RMAN
> here either
> but its more because my backup method works wonders
> and I just
> don't need those extra features that RMAN provides.
>
>
> There are a lot of sites out there that cannot
> afford to have
> the database come down even for 5 minutes so you
> might want
> to spend some time getting the warm fuzzies over hot
> backups.
> I swear, they work.
>
> -----Original Message-----
> Sent: Thursday, October 04, 2001 12:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I personally prefer cold backups over hot. Always
> better when the files are
> closed. But hey, this is coming from someone who
> still doesn't trust Rman
> :)
>
> Gene
>
> >>> kimberly.smith_at_gmd.fujitsu.com 10/04/01 12:40PM
> >>>
> I agree with your export statement but I must
> question this one. I cannot
> think of a single reason to get a cold backup over a
> hot backup. I can
> think of reasons for cold backups but if I was doing
> hot backups already I
> would not shutdown my database just to get a cold.
> There is a myth out
> there that hot backups are not as reliable as cold
> backups and its false.
> Your really not saving anything time wise if there
> is a crash (unless of
> course all your disks crash as you are bring up the
> database).
>
> Weekly cold backups are a good plan.
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Henry Poras
> INET: Henry.Poras_at_ctp.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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
=== message truncated ===
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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).
Received on Thu Oct 04 2001 - 16:52:27 CDT