ORA-19693 backup piece already included

Error Description:
Backup piece string already included

Error Cause:
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.



 
Solution - I

Restore database itself; restore the archivelog also and check if you have archivelogs

mount database

RMAN>list archivelog all; 

if it is there then delete it through RMAN

RMAN>delete archivelog all; 

if it is not there then croscheck

RMAN>crosscheck archivelog all;

SOLUTION II

RMAN> recover database noredo;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/24/2014 00:36:41
ORA-19693: backup piece C:\INCREMENTAL\INC_GCPJ8UC8_1_1.BAK already included

RMAN> change backuppiece 'C:\INCREMENTAL\INC_GCPJ8UC8_1_1.BAK' uncatalog;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of uncatalog command at 09/24/2014 00:35:31
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece

 RMAN> list backup;

 List of Backup Pieces for backup set 71 Copy #1
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
71      1   AVAILABLE   C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK

List of Backup Pieces for backup set 71 Copy #2
BP Key  Pc# Status      Piece Name
------- --- ----------- ----------
77      1   AVAILABLE   C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK
RMAN> change backuppiece 71 uncatalog;

uncataloged backup piece
backup piece handle=C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK RECID=71 STAMP=859077016
Uncataloged 1 objects


RMAN> change backuppiece 77 uncatalog;

uncataloged backup piece
backup piece handle=C:\INCREMENTAL\INC_GDPJ8UCN_1_1.BAK RECID=77 STAMP=859077286
Uncataloged 1 objects

RMAN> recover database noredo;

Starting recover at 24-SEP-14
using channel ORA_DISK_1

Finished recover at 24-SEP-14