This content has been marked as final. Show 3 replies
Hi Manjunath1 person found this helpful
Looking at your command output
- You are using controlfile
-Your backups are in the server filesystem
It seems like if this bakup isn't cataloged in your controlfile.
You can see which backups are cataloged in your controlfile with rman command
RMAN> LIST BACKUP;
But at the end, if you have your backups in disk, you can simply delete with operating system commands it and resync the contents of the disk with the controlfile with command
RMAN> CROSSCHECK BACKUP;
Rman will loook at your backups and mark like EXPIRED if "Object is not found either in file system (for DISK) or in the media manager (for sbt)."
After this, you just need to delete this backups from controlfile with
RMAN> DELETE EXPIRED BACKUP;
RMAN CROSSCHECK -> http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta015.htm
RMAN DELETE -> http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint003.htm#i1008500
Hi,1 person found this helpful
RMAN> delete expired backup of database;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
See ; <http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint003.htm> and <http://www.orafaq.com/forum/t/87032/2>
You can use too delete obsolete; It command delete all expired backup that are inside the retention policy.
Thanks for your reply..
Issue has been resolved, below changes have been done.
Actually all backup pieces are going to tape and I was executing the command without allocating the channel.
I allocated the channel and now its recognizing the backup pieces.
allocate channel ch00 type 'SBT_TAPE';
delete expired backup;
release channel ch00;