dbms_logstdby.unskip Tips Oracle Tips by Burleson Consulting December 9, 2011

Oracle Data Guard

UnSkipping a Table

The unskip procedure of the dbms_logstdby package to add a previously skipped table to the list of objects maintained by the SQL Apply operation. The steps required for this are similar to skipping a table. They are as follows:

• Stop the log apply service.
   

• Use the dbms_logstdby.unskip procedure to remove the filter. For example:

EXEC DBMS_LOGSTDBY.UNSKIP
(‘DML’,’REPORTS’,’ITEM’);

• Start the log apply service.
   

• Query the dba_logstdby_skip view to verify the result of the UNSKIP operation.

There are several other statement options for the dbms_logstdby.skip and unskip procedure. They will be explained in detail in Chapter 10, Data Guard PL/SQL Packages.

Logical Standby Databases with Time Lag

As explained in the section, “Physical Standby Database with Time Lag”, the time lag between the log transfer and the log apply service can be built using the DELAY attribute of the log_archive_dest_n initialization parameter on the primary database. This delay timer starts when the archived log is completely transferred to the standby site. The default value of the DELAY attribute is 30 minutes, but this value can be overridden as shown in the following example:

LOG_ARCHIVE_DEST_3=’SERVICE=logdbstdby DELAY=60’;