Re: 10g RMAN; How I DELETE a backupset?
- From: mr SunnyGuy <sunnyguy11@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Mon, 22 Aug 2005 11:25:11 -0700
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@xxxxxxxxx> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
