Database Backup and Recovery (MOSC)

MOSC Banner

"Refresh recovery failed to find archive log" during duplicate

edited Jan 23, 2024 9:12PM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓

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#")

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center