Oracle Server Manager User's Guide

Contents Index Home Previous Next

The Request Log Folder

When you click the Request Log folder tab, the Request Log folder opens and the Request Log object list and menu appear. The Request Log object list contains information about replication administration requests.

For more information about replication administration requests, see Oracle7 Server Distributed Systems, Volume II.

The following figure illustrates the Request Log object list.

Figure 8 - 24. Request Log Object List

Request Log Object List

The columns of the Request Log object list are described below:

Request Replication administrative procedure name.
Schema Name of the replicated schema associated with the request.
Status Status of the request. Possible states are Ready, Do_Callback, Await_Callback, and Error.
Time Logged Time the request was made.
Error Code Indicates the Oracle error code if the request produced an error.
Error Message Error message indicating the error that occurred while applying the request.
Source Database Database in which the request originated.
User User who made the request.
Trans ID Transaction identifier.
Object Referenced object name of the request, if applicable.
Role Role of the database making the request. Possible values are Master and Master Def.

Manually Applying Administrative Requests

Symmetric replication uses the job queues facility to execute the replication administration queue automatically at user-defined intervals. In the event that the job queues process is not able to perform its task, it becomes necessary to execute the queues manually.

Optionally, you may wish to execute the queues manually to produce deterministic behavior. To execute the replication administration queue, choose Apply Requests for Schema from the Request menu. The Apply Administration Requests property sheet appears.

The Apply Administration Requests property sheet consists of one page, called the Administration Requests page. The following figure illustrates the Apply Administration Requests property sheet.

Figure 8 - 25. Apply Requests Page of the Apply Administration Requests Property Sheet

Apply Requests Transactions: Apply Administration Requests

The Administration Requests page is described below:

Master Schema Replicated schema for which to apply the administration requests.
All Masters Notifies the job queues process at all remote databases involved in the replication of the master schema.
Local Database Apply requests only to the local database.

Dropping Administrative Requests

To drop an administration request that is no longer needed, select the request to be dropped and choose Drop from the Request menu. The Drop Administration Request alert box appears. The following figure illustrates the Drop Administration Request alert box.

Figure 8 - 26. Drop Request Alert Box

The Drop Administration Request alert box indicates the administrative request procedure name and the database from which the request was made.

Purging the Replication Administration Request Queue

To drop the entire contents of the administration request queue, choose Purge from the Request menu. The Purge Requests alert box appears as shown in the following figure.

Figure 8 - 27. Purge Requests Alert Box

Warning: Once you purge the request queue, you cannot recover the purged requests.

Contents Index Home Previous Next