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.
-----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,
> > 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 / 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: 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 (like subscribing).
Received on Mon Mar 18 2002 - 18:13:27 CST
