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).
