Hi,
Sometimes You can get ” RMAN-20261: ambiguous backup piece handle ” error.
Details of error are as follows.
RMAN-20261: ambiguous backup piece handle
Cause: more than one backup piece in the recovery catalog match the specified handle
Action: use the backup piece key to uniquely specify the backup piece
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/