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" <kirti.deshpande_at_verizon.com>
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: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 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.
> 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 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"
> > <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,
>
=== 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: hamcdc_at_yahoo.co.uk
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 Tue Mar 19 2002 - 03:33:20 CST
