Database Administration (MOSC)

MOSC Banner

LSP Hang on a transaction since 48 hours

edited Jul 4, 2016 4:19AM in Database Administration (MOSC) 1 commentAnswered

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 ;

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