ORA-19693: backup piece XXX already included

I got ” ORA-19693: backup piece XXX already included ” error in the Oracle database.

 

ORA-19693: backup piece XXX already included

Details of error are as follows.

ORA-19693: backup piece /backup/B_0MIB4K5G_1_1 already included

This backup piece was already specified for inclusion in the restore conversation. A restore conversation may process only a single instance of a backup piece.

Action:
Remove the specified duplicate backup piece in restore steps and restart the conversation.

Directory Names: /backup/

********

Encounter the following errors when trying to duplicate the database to another server using the
RMAN backup:

ORA-19693: backup piece /backup/B_0MIB4K5G_1_1 already included
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5127
RMAN-10031: RPC Error: ORA-19693 occurred during call to DBMS_BACKUP_RESTORE.RESTORESETPIECE

 

 

 

ORA-19693: backup piece XXX already included

This ORA-19693 errors are related with the backup piece in RMAN Catalog.

The location of the RMAN backup pieces at the target and auxiliary/duplicate databases are different. So, RMAN cannot see the RMAN backup pieces, because they are stored in a different directory at the auxiliary/duplicate database server.

 

To solve this error, uncatalog the backuppiece and catalog backuppiece again.

 

Issue the following RMAN commands, as shown in the example below:

RMAN> change backuppiece '/backup/B_VRIB0A1V_1_1' uncatalog;
RMAN> catalog backuppiece '/backup/B_VRIB0A1V_1_1';

 

You may issue the following RMAN commands to catalog the RMAN backup pieces in a single RMAN command:

RMAN> catalog start with '/backup/';

 

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )