RE: RMAN backup all but delete n days old

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Tue, 17 Feb 2009 14:08:53 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6F3FE_at_ADMINMAIL1.ui.uillinois.edu>



Hi,

I've never come across an easy way to do that exclusively with RMAN, but you can rely on an OS cronjob to handle that; just use RMAN for the backups and use the OS for the deletes... something like:

10 04 * * * find /u05/oradata/MyDB -name 1\*.log(or .dbf or whatever you tag your logs as) -mtime +2 -exec rm -f {} \;

  • Chris
    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of FMHabash Sent: Tuesday, February 17, 2009 1:36 PM To: Oracle-L Group Subject: RMAN backup all but delete n days old

Is there away in rman to backup all logs on disk, but delete n days old ones.
 The backup ... Logs ... Delete input does not allow to have separate criteria for backup vs. Delete.

Thanks

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 17 2009 - 14:08:53 CST

Original text of this message