Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN: How I DELETE old backupsets?

RMAN: How I DELETE old backupsets?

From: <SunnyGuy11_at_gmail.com>
Date: 22 Aug 2005 10:44:53 -0700
Message-ID: <1124732693.631331.11870@g47g2000cwa.googlegroups.com>


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 Received on Mon Aug 22 2005 - 12:44:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US