Oracle-L: RE: archivelogs and rman

From: Sonja Sehovic <sonja.sehovic_at_pbz.hr>
Date: Wed, 17 Apr 2002 07:48:29 -0800
Message-ID: <F001.004468DA.20020417074829@fatcity.com>

This is how I do it....

create script something_backup{
allocate channel c1 type disk format '/u01/oradata/sid%p_%d_%s.bck'; set limit channel c1 kbytes 512000;
resync catalog;
backup

        incremental level = 0
        filesperset  10
        tag "Full backup"
        (database include current controlfile);

release channel c1;
change archivelog all validate;
allocate channel c1 type disk format 'u02/oradata/arch_%p_%d_%s.bck'; set limit channel c1 kbytes 512000;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog until time 'trunc(sysdate-2)' delete input; release channel c1;
}

HTH,
Sonja

-----Original Message-----
Sent: Wednesday, April 17, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Sonja Sehovic
INET: sonja.sehovic_at_pbz.hr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------