Oracle8i Replication Management API Reference Release 2 (8.1.6) A76958-01 |
|
Manage Replicated Environment with APIs, 5 of 9
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.
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; /
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; /
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|