逻辑备库11.2.0.4升级到19.20，日志应用报错ORA-26808 ORA-23421

mahan

这里可以参考官方文档 ID 2809432.1


After successfully upgrading the logical standby database from 11.2.0.4 to 19.11.0.0 and with the primary still on 11.2.0.4, below error is seen while applying logs on logical standby.


ORA-26808: Apply process AS02 died unexpectedly.
ORA-23421: job number 4002 is not a job in the job queue


CHANGES
Upgraded database from 11.2.0.4 to 19.11

CAUSE
Job exists on primary under sys schema is not present in standby and hence the statement is failing and  causing the error on standby log apply
It is not required to sync 'SYS'.'JOB$' related transactions on logical standby

SOLUTION
Execute the below steps on Logical standby database to start the SQL apply:


1. Stop logical apply :


SQL> alter database stop logical standby apply;

2. Create a skip rule on sys.job$:


SQL> exec dbms_logstdby.skip('DML','SYS','JOB$');
SQL> exec dbms_logstdby.skip('SCHEMA_DDL','SYS','JOB$');

Confirm the skip rules are present:


SQL> select statement_opt, name from dba_logstdby_skip where name = 'JOB$';


3. Start logical apply :


SQL> alter database start logical standby apply;