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/

 

 122 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

blank

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply