RE: Backups in a DW Environment

Yeah, I configured RMAN on a system. Then the users didn't want me to turn off cold backups. My response was that a DBA wouldn't say there was such a thing as too many backups, so we do both.

   Specifically with noarchivelog/archivelog, if you try to recover using a backup from before you turned off archivelog, then you will have a gap in your log sequence and only be able to recover to the point you turned off archivelog. I know that you know that Mladen, but I thought maybe some lurker on the list might not.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Saturday, January 10, 2004 6:44 PM To: Multiple recipients of list ORACLE-L

On 2004.01.10 16:49, DENNIS WILLIAMS wrote:
> Gene - As a part of putting the database back in archivelog mode, I hope
you
> take another backup.

Actually, taking backup should be a part of every major intervention on the database.
Changing the database mode from noarchivelog to archivelog most certainly qualifies.
You can never be too rich or have too many backups. My experience tells me that
the backup you will need the most will always be the one you don't have. Murphy must
have been a DBA.

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).