Oracle Server Manager User's Guide

The Masters Folder

When you click the Masters folder tab, the Masters folder opens and the Master object list and menu appear. The Master object list contains information about the remote databases involved in the replication of each schema.

For more information about replicated schemas and master sites, see Oracle7 Server Distributed Systems, Volume II.

The following figure illustrates the Master object list.

Figure 8 - 11. Master Object List

Master Object List

The columns of the Master object list are described below:

Schema Name of the replicated schema.
Remote Master Database Remote database that is involved in the replication of the schema.
Master Def Whether or not the remote database is the master definition site for the replicated schema.
Refresh Master For snapshot sites, whether or not the remote database is the current refresh master.
Comment User comments for the remote master database.

Adding a Master Database to the Replication Environment

To add master sites to a schema , choose Add from the Master menu. The Add Remote Master Database property sheet appears.

The Add Master Database property sheet consists of one page, called the Master Specifications page. The following figure illustrates the Master Specifications page.

Figure 8 - 12. Master Specifications Page of the Add Remote Master Database Property Sheet

Add Remote Master Database: Master Specifications Page

The Master Specifications page of the Add Remote Master Database property sheet is described below:

Replicated Schema Schema for which to add a remote master database. Use the pop-up menu to specify the schema.
Remote Master Database link to the new remote master.
Use Existing Objects Whether or not to use existing objects.
Click Yes to use the existing database objects at the new master site. If the object does not exist, it is created automatically.
Click No to create the object if it does not exist. If the object exists, raise the duplicateobject exception.
Copy Rows Whether or not to use data from the master definition site.
Click Yes to populate tables with data from the master definition site.
Click No if you plan to load the data yourself. You must ensure that the data is identical to that at the master site.
This operation can only be applied from a master definition site. The status of the schema must be quiescing.

Additional Information: For information about the duplicateobject exception and about specifying Use Existing Objects and Copy Rows, see Oracle7 Server Distributed Systems, Volume II.

Scheduling Automatic Execution of the Deferred Transaction Queue

To schedule when deferred transactions are executed at a remote site, choose Schedule Execution from the Master menu. The Schedule Execution property sheet appears.

The Schedule Execution property sheet consists of one page, called the Schedule Specificati . The following figure illustrates the Schedule Specification page.

Figure 8 - 13. Schedule Specification Page of the Schedule Execution Property Sheet

Schedule Execution: Schedule Specification Page

The Schedule Specificati of the Schedule Execution property sheet is described below:

Remote Masters Scrolling list containing the set of remote masters in the replication environment.
Select the remote master site(s) for which you want to schedule execution of the deferred transactions.
All Selects all master databases from the list.
None Deselects all master databases from the list.
Interval Interval at which the Deferred Transaction queue is executed. For example, to execute every 6 hours enter "sysdate + 1/4".
Next Date Next time to execute the queue.

Deferred transactions are executed by job queue processes. For information about job queue processes, see the Oracle7 Server Administrator's Guide.

Schema	Name of the replicated schema.
Remote Master Database	Remote database that is involved in the replication of the schema.
Master Def	Whether or not the remote database is the master definition site for the replicated schema.
Refresh Master	For snapshot sites, whether or not the remote database is the current refresh master.
Comment	User comments for the remote master database.

Replicated Schema	Schema for which to add a remote master database. Use the pop-up menu to specify the schema.
Remote Master	Database link to the new remote master.
Use Existing Objects	Whether or not to use existing objects.
	Click Yes to use the existing database objects at the new master site. If the object does not exist, it is created automatically.
	Click No to create the object if it does not exist. If the object exists, raise the duplicateobject exception.
Copy Rows	Whether or not to use data from the master definition site.
	Click Yes to populate tables with data from the master definition site.
	Click No if you plan to load the data yourself. You must ensure that the data is identical to that at the master site.
	This operation can only be applied from a master definition site. The status of the schema must be quiescing.

Remote Masters	Scrolling list containing the set of remote masters in the replication environment.
	Select the remote master site(s) for which you want to schedule execution of the deferred transactions.
All	Selects all master databases from the list.
None	Deselects all master databases from the list.
Interval	Interval at which the Deferred Transaction queue is executed. For example, to execute every 6 hours enter "sysdate + 1/4".
Next Date	Next time to execute the queue.