Dears,
I have primary RAC database (11.2.0.1) and single instance logical standby one.
Logical apply works fine when I skip the DML for all objects on schema (exec dbms_logstdby.skip('DML','<schema>','%')) but when I add skip for schema level (EXECUTE DBMS_LOGSTDBY.SKIP(stmt => 'SCHEMA_DDL', schema_name => '<schema>', object_name => '%')) the sql logical apply stopped.
I monitored alert/log.xml log file, it did not contain errors (standby database receives the new archived logs), when I "unskip" the "SCHEMA_DDL" it begin apply again.
I n general I have the following questions:
- Why logical apply tops when skip "SCHEMA_LEVEL" ?
- I have space shortage, can I drop some skipped schema or truncate it data ?
Kindly advice and best regards ..