rman: delete obsolete & sbt_tape backups?
dkolearyJul 22 2010 — edited Jul 25 2010Hey;
After many months of separation, I'm finally back to studying oracle backups. I'm trying to get my little test database backups cleaned up before trying it all over again. I'm running into a bit of a snag, though:
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
5 B F A SBT_TAPE 10-SEP-09 1 1 NO TAG20090910T115704
6 B F A SBT_TAPE 10-SEP-09 1 1 NO TAG20090910T115730
13 B F A DISK 21-JUL-10 1 1 NO TAG20100721T133933
I'd like those two backups from 10-sep-09 to go away. How they got there is a mystery as this is a little intel linux box. Doesn't have a tape drive and never did; but, that's beside the point.
I've tried:
RMAN> delete backup tag='TAG20090910T115730';
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=129 devtype=DISK
but the backup is still there because it's using a disk channel instead of a tape channel.
Can anyone tell me how to make these two backups go away?
Thanks for any hints/tips/suggestions
Doug O'Leary