Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Defining Obsolete Backups in RMAN

Defining Obsolete Backups in RMAN

From: <amerar_at_iwc.net>
Date: 20 May 2005 07:13:25 -0700
Message-ID: <1116598405.942008.115560@g49g2000cwa.googlegroups.com> 






Hi All,



Question:



Say I have 3 weeks of backup, and I want to get rid of everything but
one week.  Will this REPORT command give me a list of everything I can
delete:



REPORT OBSOLETE UNTIL TIME 'SYSDATE-7';


Basically, anything outside the time window will be considered
obsolete.  And, does this include backups, archive logs, and control
file copies?



We have to implement this and do not have 3 weeks to wait to test this
out.



Thanks, 



Arthur
Received on Fri May 20 2005 - 09:13:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US