| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Should we say COLD or HOT backup OR ARCHIVELOG or 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:kirti.deshpande_at_verizon.com] Sent: Tuesday, March 19, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Should we say COLD or HOT backup ORARCHIVELOG 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. dwilliams_at_lifetouch.com -----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 " <Robert_Freeman_at_csx.com> wrote: > I can read your question 2 ways, so let me answer itMailing Lists
> 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"
> <ORACLE-L_at_fatcity.com>
> 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,
> > when we talk about cold backups if the terminology
> should not include the
> > mode of the backup:
> >
> > cold archivelog mode backup
> > cold noarchivelog mode backup
> >
> > When we say "cold" backup, do we just assume it's
> NOARCHIVELOG mode...and
> > enjoy the fact that we don't have to type or say
> as much...or should we be
> > more specific to help the junior DBA's (or perhaps
> even those out there
> who
> > have never really considered that there is a
> distinction between the two)
> > out there? When books are written, I notice that
> they mostly just talk
> about
> > hot and cold backups, assuming that the cold
> backup is in NOARCHIVELOG
> > mode...
> >
> > what about the junior DBA who does a cold backup
> in ARCHIVELOG mode and
> > follows the standard cold backup procedure
> (backing up control files and
> > redo logs) assuming that he can just recover
> them....(granted, anyone
> should
> > test
> > their backup and recovery strategy, but this is a
> Jr. DBA!)
> >
> > Just thinking aloud... is it a silly question?
> >
> > 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.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Freeman, Robert
> > INET: Robert_Freeman_at_csx.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: Big Planet
> INET: bigplanet34_at_hotmail.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: Freeman, Robert
> INET: Robert_Freeman_at_csx.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).
===== 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: hamcdc_at_yahoo.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access /
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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.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: Deshpande, Kirti INET: kirti.deshpande_at_verizon.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 (likesubscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sg 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 Mon Mar 18 2002 - 19:03:26 CST
 |
 |