Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> RMAN: How I DELETE old backupsets?
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
![]() |
![]() |