1. 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?
2. 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 <[EMAIL PROTECTED]> 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 :) * > > >>> <[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 > > __________________________________________________ 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: [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).