Re: RMAN questions

From: Dave Hau <davehau-no-spam-123_at_no-spam.netscape.net>
Date: Wed, 25 Jun 2003 15:55:53 GMT
Message-ID: <dCjKa.3242$N73.3098@newssvr16.news.prodigy.com>

"bcjm" <oldcar_at_hotmail.com> wrote in message news:6e9fcca4.0306250402.5e44a9ba_at_posting.google.com...
> Sure you can report the obsolete but how do you delete them automatically?
>

Take a look at the script I quoted in my original reply. Again, it's

$ORACLE_HOME/rdbms/demo/rman1.sh

Cheers,
Dave

>
> 2. How do you delete the obsolete backup file (backupset)
> automatically? Say I do a full backup to disk daily. I only want to
> keep the past 7 days backupset. I did not find a commend which allows
> me to delete backupset that are older than 7 days. For archivelog
> file I can issue "change archivelog until time='sysdate-7' delete;"
> but not the backupset.

Take a look at $ORACLE_HOME/rdbms/demo/rman1.sh

In your case, you might want to change the report obsolete line to:

report obsolete until time 'SYSDATE-7' Received on Wed Jun 25 2003 - 10:55:53 CDT