rman for a data warehouse

From: Steiner, Randy <RASTEIN_at_NYCT.com>
Date: Wed, 18 Feb 2004 14:47:41 -0500
Message-ID: <A9461F6194CBD411B1BF0008C791F91E02711E03@EMS26>

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_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 Wed Feb 18 2004 - 13:47:41 CST