Oracle in a Nutshell

Calls

PROCEDURE DBMS_LOGSTNDBY.APPLY_SET (parameter IN VARCHAR2, value IN VARCHAR2);

Lets you set parameter to value. For more information on the parameters that can be set, see the Oracle documentation.

PROCEDURE DBMS_LOGSTDBY.APPLY_UNSET (parameter IN VARCHAR);

Reverses the values applied with the APPLY_SET procedure.

PROCEDURE DBMS_LOGSTDBY.BUILD;

Used to preserve LogMiner dictionary information in the redo logs.

PROCEDURE DBMS_LOGSTDBY.GUARD_BYPASS_OFF;

Reenables the database guard feature that was previously bypassed with the GUARD_BYPASS_ON procedure.

PROCEDURE DBMS_LOGSTDBY.GUARD_BYPASS_ON;

Turns off the database guard that protects the logical standby from modifications. Typically used for maintenance or problem correction on the standby, but not for transactions, because triggers and constraints are not used.

PROCEDURE DBMS_LOGSTDBY.INSTANTIATE_TABLE (table_name IN VARCHAR2, schema IN VARCHAR2, dblink IN VARCHAR2);

Creates table_name in schema of dblink.

PROCEDURE DBMS_LOGSTDBY.SKIP (statement_option IN VARCHAR2, schema_name IN VARCHAR2, object_name IN VARCHAR2, proc_name IN VARCHAR2);

Defines filter, defined by keywords in statement_option, to prevent certain SQL statements on object_name in schema_name from being applied to the logical standby database, based on rules defined in proc_name.

PROCEDURE DBMS_LOGSTDBY.SKIP_ERROR (statement_option IN VARCHAR2, schema_name IN VARCHAR2, object_name IN VARCHAR2, proc_name IN VARCHAR2);

Called when log apply services encounter ...