- If you can afford to lose data from the time of the
last backup, then you are right. However, I even put
those databases on 24x7 mode whenever possible because
(1) Developers, like DBAs, work strange hours in the
night and day and would probally like to have access
to the database. (2) You never had a developer be
pissed off at you because you couldn't restore one
table without having to wipe out all the work he or
jack did earlier today. (3) How can you truely test a
24x7 application on a non 24x7 Oracle database when
now the SGA differs between the two machines?
- I am a strong believer of the KISS philosophy as
well, you guys haven't seen my users! This, however,
should not apply to us as DBAs whose job is to know
DBA related commands.
Regards,
Satar
- Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote:
> 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 :) *
>
> >>> <Jared.Still_at_radisys.com> 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
>
>
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: satar naghshineh
INET: satarnag_at_yahoo.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).
Received on Thu Oct 04 2001 - 16:54:28 CDT