Automatic backups in Exacs failing with RMAN-12017: could not locate pieces of backup set key (Doc ID 2909815.1)

Last updated on APRIL 29, 2024

Applies to:

Symptoms

++ Automatic backups in Exacs failing with RMAN-12017 during validation of backup :

RUN {
2022-10-31 20:17:33.694978 -  -> ALLOCATE CHANNEL SBT_1 DEVICE TYPE SBT parms='SBT_LIBRARY=/var/opt/oracle/dbaas_acfs/IFEBSPRD/opc/libopc.so, ENV=(OPC_PFILE=/var/opt/oracle/dbaas_acfs/IFEBSPRD/opc/opcIFEBSPRD.ora)' ;
2022-10-31 20:17:33.695153 -  -> ALLOCATE CHANNEL SBT_2 DEVICE TYPE SBT parms='SBT_LIBRARY=/var/opt/oracle/dbaas_acfs/IFEBSPRD/opc/libopc.so, ENV=(OPC_PFILE=/var/opt/oracle/dbaas_acfs/IFEBSPRD/opc/opcIFEBSPRD.ora)' ;
2022-10-31 20:17:33.695951 -  ->   ALLOCATE CHANNEL DISK_1 DEVICE TYPE DISK;
2022-10-31 20:17:33.696092 -  -> RESTORE DATABASE PREVIEW VALIDATE HEADER;
2022-10-31 20:17:33.696203 -  -> }
2022-10-31 20:17:33.696329 - Verifying Missing Bkup Pieces
2022-10-31 20:17:33.713430 - RMAN-12017: could not locate pieces of backup set key 93486
2022-10-31 20:17:33.713561 - RMAN-12017: could not locate pieces of backup set key 93494
2022-10-31 20:17:33.713646 - RMAN-12017: could not locate pieces of backup set key 93495

2022-10-31 22:26:18.906901 - Verifying Missing Bkup Pieces
2022-10-31 22:26:18.926552 - RMAN-12017: could not locate pieces of backup set key 93491
2022-10-31 22:26:18.926736 - RMAN-12017: could not locate pieces of backup set key 93493
2022-10-31 22:26:18.927068 - OBKUP:: VALIDATING DATABASE BACKUPS:
2022-10-31 22:26:18.927251 -  ->  Failed to validate backup pieces

++ But Backups are getting completed successfully at RMAN level for both database and archived logs:

2022-10-31 22:21:13.423743 -       RMAN-08530: piece handle=qn1bm9l1_94039_1_1-IFEBSPRD-DBTRegular-L11667226410851659--XP-19-1887389673-20221031 tag=DBAAS_FULL_BACKUP20221031201248 comment=API Version 2.0,MMS Version 12.2.0.2
2022-10-31 22:21:13.423856 -       RMAN-08540: channel SBT_1: backup set complete, elapsed time: 01:03:21
2022-10-31 22:21:13.423947 -       RMAN-03091: Finished backup at 31-OCT-2022 22:19:39

Version 2.0,MMS Version 12.2.0.2
2022-10-31 22:21:13.427515 -       RMAN-08540: channel SBT_1: backup set complete, elapsed time: 00:00:15
2022-10-31 22:21:13.427605 -       RMAN-03091: Finished backup at 31-OCT-2022 22:20:31
2022-10-31 22:21:13.427692 -       
2022-10-31 22:21:13.427778 -       RMAN-03090: Starting Control File and SPFILE Autobackup at 31-OCT-2022 22:20:31
2022-10-31 22:21:13.427864 -       RMAN-08503: piece handle=c-1887389673-20221031-2d-DBTRegular-L11667226410851659 comment=API Version 2.0,MMS Version 12.2.0.2
2022-10-31 22:21:13.427950 -       RMAN-03091: Finished Control File and SPFILE Autobackup at 31-OCT-2022 22:20:35

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.