I see 2 advantages of cold over hot backups:
1) Archive log mode not required for cold backups. Dev & Test DB's do not need
archive space.
2) Cold backups follow the KISS principle. Shutdown db, tar, dump, cpio, dd, etc. the
datafiles, redo logs, ctl files, oracle filesystems, etc. to tape, Startup db, Done.
Take the tape to same or another server and restore, No Oracle cmds required
(filesystems being the same). Now for Hot Backups, we have to add a step. Not a big
step :) We need the arcs and need to recover the db.
Gene
* Still not convinced backing up closed files are not safer/better than open files :) *
>>> <[EMAIL PROTECTED]> 10/04/01 04:59PM >>>
OK, I'll bite, what OS commands?
As for cold backups, and I'm sure you've heard this already, they're only
really needed after you open a database with 'resetlogs' . Otherwise it
is not necessary to use a cold backup.
Jared
"Gene Sais"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ach.fl.us> cc:
Sent by: Subject: RE: Backup Strategy
[EMAIL PROTECTED]
10/04/01 02:10 PM
Please respond to
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
>>> [EMAIL PROTECTED] 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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
