Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN need for alter system archive log all

RMAN need for alter system archive log all

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 23 Sep 2002 13:43:25 -0800
Message-ID: <F001.004D7314.20020923134325@fatcity.com>


List - I am wrapping up my RMAN procedures so I can turn off conventional backups and still sleep at night. I am on Oracle 8.1.6. Does anyone know the answer to this question: If I do an RMAN backup to disk, then copy the RMAN backup pieces to tape, and copy the archive logs to tape, do I need to execute an ALTER SYSTEM ARCHIVE LOG ALL before I copy the archive logs to tape? This has been necessary for hot backups, but I can't recall this being mentioned specifically for RMAN. I want to be able to recover the database from the contents of the backup tape alone, and I noticed during my disaster recovery tests that you definitely needed to have required archive logs available.

 
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
--

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 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). Received on Mon Sep 23 2002 - 16:43:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US