I am trying to use rman for my data warehouse which is in no archive mode.
I only have room for 1 backup and need to remove last weeks backup prior to
doing this weeks backup.

I set the retention period to:
 CONFIGURE RETENTION POLICY to recovery window of 6 days;

And the first lines of my backup script is:
 CROSSCHECK BACKUP OF DATABASE;
 DELETE NOPROMPT OBSOLETE;

If I execute Report Obsolete prior to running my backup (7 days after the
last backup) rman reports nothing and Delete Obsolete does not remove last
weeks backup.

If I run
 select *
 from v$backup_piece
 where status = 'A';

Then I see last weeks backup.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------