Tuesday, 29 November 2011

Handling Logical Standby Database Failures

An significant device for management ordered standby database flops is the  
DBMS_LOGSTDBY.SKIP_ERROR procedure. Depending on how significant a table is, 
you might desire to manage one of the following:
  • Ignore flops for a table or exact DDL
  • Associate a retained method with a filter so at runtime a conclusion can be                                        made about skipping the declaration, executing this declaration, or executing a                         replacement statement
Taking one of these activities stops SQL Apply from stopping. Later, you can query the DBA_LOGSTDBY_EVENTS outlook to find and correct any difficulties that exist.