Lets not forget also the benefit of archive log to allow only restored of a subset of files in the event of a recovery. In noarchivelog, if you lose one file, you'll typically need to restore the lot. In archivelog, you'll typically need to restore just the one
hth connor --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > No no.. You are correct. > > In my case, since no changes are made to the > database other than the data > loads, and there are no issues about recovering from > the last cold backup & > the downtime involved, we can live with noarchivelog > mode. That's all. > > Cold backups with noarchivelog mode are useless if > point-in-time recovery is > desired. > > It all depends on the requirements. > > - Kirti > > -----Original Message----- > Sent: Monday, March 18, 2002 7:03 PM > To: Multiple recipients of list ORACLE-L > NOARCHIVELO > > > Hi, > > Pardon me if I am wrong, I thought the only reason > for the database to be in > archive log mode is so that I can recover the > database up to the time when > the database crushes. > > For example, we do cold backup nitely. If the > database were to crush etc at > 2pm, I would be able to recover my database up to > 2pm by using the cold > backup and the archive log generated until 2 pm. > > However, if my database has no archivelog, I can > only recover my database > using the backup last nite. > > In my opinion, database in archive log mode is very > important if I need to > be able to recover the database up to the point of > failure. > > Please correct me if I am wrong. Thanks. > > Regds, > New Bee > -----Original Message----- > From: Deshpande, Kirti > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 19, 2002 8:13 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Should we say COLD or HOT backup OR > ARCHIVELOG or NOARCHIVELO > > Here is en exception: > I happen to administer a couple of data mart > databases, that > are loaded once > or twice a month. Both run in noarchive log mode. > This is > how these have > been set up when we started back in 1998. We take > cold > backups after the > data load, table/partition analyze. It takes 5 > hours max on > a Sunday. No > other changes are made to any of the data till the > next data > load. > We have yet to see a reason for these databases to > be > running in archivelog > mode. In the worst case, the recovery of the > largest db > (80GB) is about 8 > hours from backups (Yes, we do DRP drills). And > that type of > downtime is > perfectly alright with the business and end users. > > > - Kirti > > -----Original Message----- > Sent: Monday, March 18, 2002 4:59 PM > To: Multiple recipients of list ORACLE-L > NOARCHIVELO > > > Connor - Good points, but obviously there are > exceptions. We > have a data > warehouse that we keep in NOARCHIVELOG mode. After > the > weekly load we do a > cold backup. However, lately there has been talk > of some > updates during the > week, so that may have to change. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Monday, March 18, 2002 3:28 PM > To: Multiple recipients of list ORACLE-L > NOARCHIVELO > > > Just to add to the controversy, I often make the > argument to developers/users/managers/etc that > noarchivelog does not exist. > > In my opinion, 'noarchivelog' is like waving a > flag > saying "I stand an excellent chance of losing a > whole > lot of data one day". > > Some years ago at a place I worked, some idiot > came up > with some piece of nonsense along the lines of "We > don't make any changes, we do a cold backup each > night, and we can easily reapply the flat files > that > are sqlldr'd into the db each morning"... and thus > went for a noarchivelog strategy. > > When it did go belly up, this "simple" option > turned > into a nightmarish exercise... > > Even worse, the idiot happened to be me at the > time > :-) > > --- "Freeman, Robert " <[EMAIL PROTECTED]> > wrote: > I can read your question 2 ways, so let > me > answer it > > both ways... > > > > If you are asking if you can only do a cold > backup > > when in noarchivelog > > mode, you are correct. > > > > However, in archivelog mode you can do cold or > hot > > backup. The procedure is > > a bit different in archivelog mode, because of > the > > recovery implications of > > being in archivelog mode. > > > > RF > > > > Robert G. Freeman - Oracle8i OCP > > Oracle DBA Technical Lead > > CSX Midtier Database Administration > > > > The Cigarette Smoking Man: Anyone who can > appease a > > man's conscience can > > take his freedom away from him. > > > > > > > > -----Original Message----- > > Sent: Monday, March 18, 2002 1:28 PM > > To: Multiple recipients of list ORACLE-L > > NOARCHIVELOG mo > > > > > > but isn't cold backup is possible only if ur > running > > in noarchieve mode else > > you have to go for hot backup. > > BigP > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Monday, March 18, 2002 7:41 AM > > > > > > > Ok.... maybe you will think this is a silly > > thread, but I've wondered > > > about this before... > > > > > > We (DBA's) use the terms hot and cold backups > all > > the time. I wonder > > though, > === 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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).