1 person found this helpful
When ever posting the question mention your database version - Also in this context what sort of backup are u taking about ?
If understand correctly - I think its not possible to delete some contents from the rman backup picies
Oh of course, just forget that, i'm sorry.
Oracle version: 126.96.36.199.0
Backups where taking with RMAN
OS: Ret Hat 6
> i want to delete only this datafile from the backup
It's not possible to delete a datafile from a backup that has already been created. That would require rewriting the backup pieces (a datafile may span more than one backuppiece), updating the catalog in the controlfile and updating the catalog schema. Rewriting the backup pieces would be the biggest job -- multiple datafiles may be interleaved in the same backup pieces.
You'd have to wait for the backup to become obsolete (according to your retention policy) and then delete the obsolete backup in it's entirety.
Hemant K Chitale
Thanks a lot! I already thought that but no question is a stupid question