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

Home -> Community -> Mailing Lists -> Oracle-L -> archivelogs and rman

archivelogs and rman

From: Malik, Fawzia <Fawzia.Malik_at_bskyb.com>
Date: Wed, 17 Apr 2002 06:58:27 -0800
Message-ID: <F001.004466E7.20020417065827@fatcity.com>

Hi

I would like to set up rman so that it backs up archivelogsand deletes them. However I want rman to delete those which are sysdate-2 (i.e. want to keep about a day or 2 archivelogs on disk so an os backup can also be performedfor  added precaution)..
would this be correct:

  backup

           format '/var/backups/oracle/rman/al_%d_s%s_p%p'
           ( archivelog until time 'SYSDATE-2' delete input );

Any help/advice would be greatly appreciated

Rgds

Fawzia



Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone.
Thank you for your co-operation.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Malik, Fawzia
  INET: Fawzia.Malik_at_bskyb.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 Wed Apr 17 2002 - 09:58:27 CDT

Original text of this message

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