In this post, you’ll learn more about the Oracle ErrorRMAN-08167: WARNING: string encountered a piece that was in use with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
RMAN-08167: WARNING: string encountered a piece that was in use
Reason for the Error RMAN-08167: WARNING: string encountered a piece that was in use
The backup piece is currently in use by another BACKUP, RESTORE or DELETE operation.
How to fix the Error RMAN-08167: WARNING: string encountered a piece that was in use ?
You can fix this error in Oracle by following the below steps
Use LIST to determine if backup has been deleted. If not deleted, then check if any process is hung while accessing the piece and terminate them before retrying DELETE. If using SBT device, then check Media Manager as well. Alternatively, consider the command DELETE FORCE.