Managing the Error Queue

As an administrator of a replication environment, you should regularly monitor the error queue to determine if any deferred transactions were not successfully applied at the target master site.

To check the error queue, issue the following SELECT statement as the replication administrator when connected to the target master site:

SELECT * FROM deferror;

If the error queue contains errors, you should resolve the error condition and re-execute the deferred transaction. You have two options when re-executing a deferred transaction: you can re-execute in the security context of the user who received the deferred transaction or you can re-execute the deferred transaction with an alternate security context.

Re-execute Error Transaction as the Receiver

The procedure below re-executes a specified deferred transaction in the security context of the user who received the deferred transaction. This procedure should not be executed until the error situation has been resolved.

Executed As: Replication Administrator

Executed At: Site Containing Errors

Replication Status: Normal

CONNECT repadmin/repadmin@orc2.world

BEGIN
   DBMS_DEFER_SYS.EXECUTE_ERROR (
      deferred_tran_id => '128323',
      destination => 'ORC2.WORLD');
END;
/

Re-execute Error Transaction as Alternate User

The procedure below re-executes a specified deferred transaction in the security context of the currently connected user. This procedure should not be executed until the error situation has been resolved.

Executed As: Connected User

Executed At: Site Containing Errors

Replication Status: Normal

CONNECT scott/tiger@orc2.world

BEGIN
   DBMS_DEFER_SYS.EXECUTE_ERROR_AS_USER (
      deferred_tran_id => '128323',
      destination => 'ORC2.WORLD');
END;
/