i just want to find a way to delete only a part of a backup. For example: I have three tablespaces with its own datafiles and that three will be saved in a backup. Now i have deleted the second tablespace with its datafile and i want to delete only this datafile from the backup.
Is there any way to do that?
Thanks a lot and regards,
> 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