RE: Delete obsolete in RMAN on 8.1.7.4

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 11 Apr 2005 11:22:08 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0704AC044B@exchsen0a1ma>

Mike,

You can use this script to purge rman backups. Change the value from 30 to whatever number of days you want to purge beyond. Run this as the Rman user in sql plus (connecting to the Rman repository). It will produce an Rman script to be run thru Rman to purge old backups. I run this twice a month.

Ruth's recovery window probably does what this does. But I wrote this back before the recovery window thing became available.

     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 ' || ' disk;' from dual;
     select 'change backuppiece '||bp.bp_key||' delete;'
     from rc_backup_piece bp,rc_database db 
     where db.name = upper('$DBNAME') 
     and bp.db_id = db.dbid 
     and bp.start_time < sysdate-30; 
     select 'exit;' from dual; 
     spool off 
     exit

Good Luck!

Tom

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

From: Kline.Michael [mailto:Michael.Kline_at_SunTrust.com] Sent: Monday, April 11, 2005 10:47 AM
To: oracle-l_at_freelists.org
Subject: Delete obsolete in RMAN on 8.1.7.4

It appears the delete obsolete doesn't work in 8.1.7.4 of RMAN.

Yet I can report obsolete which goes WAY back.

How do or can I trim this list. We keep about 6 months, but report obsolete is going back almost 2 years now.

This is on SUN if it matters.

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. [ST:A234]

--

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

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 11 2005 - 11:26:20 CDT