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

Home -> Community -> Mailing Lists -> Oracle-L -> 10g RMAN; How I DELETE a backupset?

10g RMAN; How I DELETE a backupset?

From: mr SunnyGuy <sunnyguy11_at_gmail.com>
Date: Mon, 22 Aug 2005 10:43:11 -0700
Message-ID: <99c0eae505082210437575711f@mail.gmail.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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 22 2005 - 12:45:28 CDT

Original text of this message

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