Oracle 19c -- RMAN delete archivelogs fails with RMAN-00600: internal error, arguments [8714]

Problem

On a Oracle 19c far sync instance, RMAN delete archivelog command fails with the errors:

 

RMAN> delete archivelog all;

Starting implicit crosscheck backup at 29-JUN-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=266 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code for command delete : 600
RMAN-00600: internal error, arguments [8714] [] [] [] []

 

Though the list archivelog command works:

RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name MYDBFS
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1117    1    76      A 29-JUN-21
        Name: /opt/oracle/fra/MYDBFS/archivelog/2021_06_29/o1_mf_1_76_jfngyp3j_.arc

1118    1    77      A 29-JUN-21
        Name: /opt/oracle/fra/MYDBFS/archivelog/2021_06_29/o1_mf_1_77_jfngyq1p_.arc

Solution

This is probably due to unpublished Bug:29041036.

 

There is no workaround to make RMAN work and delete archivelog files.

 

But the archivelog files may be deleted using the DBMS_BACKUP_RESTORE package called as the SYS user

begin
  for c1 in (
    select RECID, STAMP, NAME, THREAD#, SEQUENCE#, RESETLOGS_CHANGE#, FIRST_CHANGE#, BLOCK_SIZE
    from   v$archived_log
    where  STANDBY_DEST='NO' and deleted='NO'
  )
  loop
     dbms_backup_restore.deleteArchivedLog(
        c1.RECID,
        c1.STAMP,
        c1.NAME,
        c1.THREAD#,
        c1.SEQUENCE#,
        c1.RESETLOGS_CHANGE#,
        c1.FIRST_CHANGE#,
        c1.BLOCK_SIZE);
  end loop;
end;

Adjust the WHERE clause accordingly 

 

References:

• Bug 29041036 - RMAN-00600 [8714] in far sync instance even after applying 20549013 (Doc ID 29041036.8)