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,
> > 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: [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).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Big Planet
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Freeman, Robert
> 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).
=====
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
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).
