RE: Delete obsolete in RMAN on 8.1.7.4
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'Michael.Kline@xxxxxxxxxxxx'" <Michael.Kline@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 11 Apr 2005 11:22:08 -0400
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@xxxxxxxxxxxx]
Sent: Monday, April 11, 2005 10:47 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx
************************************************
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]
************************************************
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
