Re: 10g RMAN; How I DELETE a backupset?

Hi,

I got this RMAN command to work:

DELETE OBSOLETE REDUNDANCY = 1; Now that I think about it; it's more in line with what I want:

Delete all backups except the last one.

-msg

On 8/22/05, mr SunnyGuy <sunnyguy11_at_gmail.com> wrote:
> Hi,
>
> I'm starting to work with RMAN on my 10g DB.
>
> I found that it was pretty easy to use it to backup my database.
>
> How do I use it to toss EXPIRED BACKUPSETs in the trash?
>
> For example:
>
> I use:
>
> LIST BACKUPSET OF DATABASE;
>
> I see 3 backup sets.
>
> The first one has Completion Time of 2005-08-15.
>
> I issue this command:
>
>
> RMAN> DELETE FORCE EXPIRED BACKUPSET OF DATABASE DEVICE TYPE DISK
> COMPLETED BEFORE "TO_DATE('08/16/2005 00:00:00','MM/DD/YY
> HH24:MI:SS')";
>
> I see this:
>
> released channel: ORA_DISK_1
> allocated channel: ORA_DISK_1
> channel ORA_DISK_1: sid=276 devtype=DISK
>
> Then, I run
>
> LIST BACKUP OF DATABASE;
>
> My backup is still there.
>
> I use ls to check the backup location.
> I see that my backup is still there.
>
> So,
> How do I use RMAN to DELETE backups that I don't want anymore?
>
> Thanks,
>
> -msg
>

--
http://www.freelists.org/webpage/oracle-l