RE: Rman 8i vs 9i question - delete obsolete

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 27 Feb 2004 13:20:23 -0500
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD594F@exchsen0a1ma>

Rick,

Here is how I do it. Run this while connected to the Rman catalog as the Rman user. Provide your database name when it asks for it. This script will select all backups that are more than 90 days old, and will generate a the Rman script to delete those backups from the catalog. You then simply run the resulting script thru Rman and the backups get purged. Feel free to modify any part of this that you need to - it's not copywrited! Hope this helps.

set heading off
set feedback off
set newpage 1
set pagesize 999
set linesize 60
spool Rman_Purge.rcv
select 'allocate channel for maintenance type ' || '''' || 'SBT_TAPE' || '''' || ';' from dual;
select 'change backuppiece '||bp.bp_key||' delete;' from rc_backup_piece bp,rc_database db
where db.name = upper('%1')
and bp.db_id = db.dbid
and bp.start_time < sysdate-90
/
exit

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Rick Stephenson [mailto:RStephenson_at_Ovid.com] Sent: Friday, February 27, 2004 1:07 PM
To: Oracle ListServ (oracle-l_at_freelists.org) Subject: Rman 8i vs 9i question - delete obsolete

In 9i rman I can set the retention policy to whatever I want and delete all obsolete backups based on that setting.

I cannot find, however, a similar feature for 8i rman. Is there a way to set this, and if not, how does rman determine what an obsolete backup is?

Thanks,

Rick Stephenson

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Feb 27 2004 - 12:17:41 CST