I put all databases in archive mode, i.e. dev, test, and production.
I can use test db's to test backup/recovery scenario's. The only time they
are not in archive mode is when I am doing a major load
(import,sqlload,etc). After I am done loading data, I put them back into
archive mode. What does it cost you, a few archives? Ha, well worth
it :).
>>> Mark.Bobak@il.proquest.com 01/09/04 04:54PM
>>>
My personal opinion is all production databases should be in
archivelog
mode. Period. End of story.
Less down time,
more recovery options....it's all good.
Having said that, given a
specific business case, with a specific set of
requirements, one could argue
for noarchivelog mode, and you might even
convince me...but I doubt
it...;-)
-Mark
Mark J. Bobak
Oracle DBA
ProQuest
Company
Ann Arbor, MI
"Imagination was given to man to compensate him for
what he is not, and
a sense of humor was provided to console him for what he
is." --Unknown
-----Original Message-----
Sent: Friday,
January 09, 2004 4:25 PM
To: Multiple recipients of list
ORACLE-L
Have a question on backups in a DW environment.
Our
DW is somewhat small at the moment but projected
to grow. I seem to be
having a hard time trying to
convince the sys admin that I don't want
archive
logging turned on. To me, it does'nt make much
sense.
He's proposed using EMC BCV's which I've agreed to
(and also
sounds like a good idea) but also wants to
turn on archiving. My
thinking is why turn on
archiving if I can restore my DB from last
night's
BCV's and then bring it up to date by re-loading any
data that was
loaded after the BCV split.
Our system is not 24x7 so we can shutdown
before the
BCV split. Also, it's not directly accessed by users
for
ad-hoc queries. Automated processes access the
database and build cubes
using Cognos tools. Users
access these and not the DB
directly.
So, again I don't see the need for archive logging.
Any
thoughts?
mohammed
__________________________________
Do
you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net--
Author:
mkb
INET: mkb125@yahoo.com
Fat City Network
Services -- 858-538-5051
http://www.fatcity.comSan Diego,
California -- Mailing list and web
hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
ListGuru@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.net--
Author: Bobak, Mark
INET: Mark.Bobak@il.proquest.com
Fat
City Network Services -- 858-538-5051
http://www.fatcity.comSan Diego,
California -- Mailing list and web
hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
ListGuru@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).