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:
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |