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,
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