RMAN-20261: ambiguous backup piece handle

Hi,

Sometimes You can get ” RMAN-20261: ambiguous backup piece handle ” error.

Details of error are as follows.

RMAN-20261: ambiguous backup piece handle

This error is related with the backuppiece.

Change backup piece and uncatalog it.

RMAN> change backuppiece '/backup/rman/incremental_1.bck' uncatalog;


RMAN-0051453: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-0051453: ===========================================================
RMAN-03002: failure of uncatalog command at 28/04/2020 12:24:25
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece

list backup.

RMAN> list backup;

List of Backup Pieces for backup set 1453 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
1453 1 AVAILABLE /backup/rman/incremental_1_1.bck

List of Backup Pieces for backup set 1453 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
1463 1 AVAILABLE /backup/rman/incremental_2_1.bck

Change backup piece and uncatalog them.

RMAN> change backuppiece 1453 uncatalog;

uncataloged backup piece
backup piece handle=/backup/rman/incremental_1_1.bck RECID=1453 STAMP=85901463016
Uncataloged 1 objects


RMAN> change backuppiece 1463 uncatalog;

uncataloged backup piece
backup piece handle=/backup/rman/incremental_1_1.bck RECID=1463 STAMP=85901463286
Uncataloged 1 objects

Try again.

RMAN> recover database noredo;

Starting recover at 28-APR-20
using channel ORA_DISK_1

Finished recover at 28-APR-20

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/