IT Tutorial

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
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/

 

 450 views last month,  1 views today

Exit mobile version