"Refresh recovery failed to find archive log" during duplicate
Oracle 19.20.0.0.0. Linux 64-bit. RHEL 8.9. Source database is 4-node RAC. Target database 2-node.
Everyday we run
DUPLICATE PLUGGABLE DATABASE EIWP AS EIWPCL TO CEIWPCL FROM ACTIVE DATABASE SECTION SIZE 100G;
to clone a PDB from the source DB to the target DB. Once every two weeks or so, the target side alert.log shows errors like
EIWPCL(3):Media Recovery Log +FRA/CEIWPCL/ARCHIVELOG/2024_01_04/thread_4_seq_62203.5679.1157411859 EIWPCL(3):Refresh recovery failed to find archive log for thr-1, scn-580330688453
But if we check inside asmcmd, the archive log reported missing does exist. (The sequence of the log is found by "select sequence# from v$archived_log where thread#=1 and 580330688453 between FIRST_CHANGE# and NEXT_CHANGE#")