LSP Hang on a transaction since 48 hours
Hi All,
the sql applier starts to apply changes on table "PROD"."TAB_23201241" but this table is not important, because it has been deleted on primary. the problem that the sql applier is applying changes on it since 48 hours ... and block all other transactions ....
I used skip procedure to skip it, but after restart the sql apply .. the same problem occur ... my question how to force the sql apply to skip it ?
alter database stop logical standby apply ;
begin
dbms_logstdby.skip('DML','PROD','TAB_23201241');
dbms_logstdby.skip('SCHEMA_DDL','PROD','TAB_23201241');
end;
/
alter database start logical standby apply immediate ;