7
Introduction to the Replication Management Tool< /h1>

The Replication Management tool is part of the Oracle Enterprise Manager C onsole and provides a graphical user interface (GUI) for setting up, managing, and monitoring a replication environment. The Replicat ion Management tool includes wizards that guide you through many important operations. You can use the Replication Management tool to manage both multimaster and materialized view replication environments.

This chapter introdu ces you to the features of the Replication Management tool. However, the primary documentation for using this tool is the Replication Management tool online help.

This chapter contains these topics:

• Usage Scenarios for the Replication Management Tool
< li class="LB1" type="disc">Logging into the Replication Management Tool
• The Replication Management Tool Interface
• The Replication Management Tool Wizards
• Flowchart for Creating a Replication Environment

  See Also: The Replication Management tool online help for detailed instructions about using the Replication Management tool The Oracle Ent erprise Manager Console documentation set and online help for information about using the Oracle Enterprise Manager Console

Usage Scenarios for the Replication Management Tool

Using the Replication Management tool, you can:

• Set up master si tes and materialized view sites
• Add master sites to and remove master sites from a replication environment
• Create and manage master groups
• Monitor master sites and materialized view sites with a topology view, reports, and statistics
< li class="LB1" type="disc">Create and manage materialized view logs
• Create and manage materialized view groups
• Create and manage individual materialized views
• Create and manage refresh groups for materialized views
• Create and manage deployment templates
• Package deployment templates for offline instantiation. Note that you must use the replication management API to package deplo yment templates for online instantiation.
• Configure conflict resolution methods< /li>
• Create, monitor, and manage scheduled links
• Monitor and manage administrative requests
• Monitor and manage d eferred transactions
• Monitor and manage error transactions
• Create, monitor, and manage local jobs

Logging into the Replication Management Tool

The Replication Management Tool Interface

The Replication Manageme nt tool interface in the Oracle Enterprise Manager Console includes a toolbar on the far left and two panes: the navigator pane on th e left and the right pane. The navigator pane displays a tree structure for your databases, and the right pane displays property shee ts.

Figure 7-1 The Replication Management Tool in Oracle Enterprise Manager Console

Text description of the illustration intro.gif

Navigator Pane

The navigator pane in the Oracle Enterprise Manager Console functions the same way as i t does in other Oracle Enterprise Manager Console applications. That is, the navigator pane lets you:

• Access all of the nodes in your replication environment
• Expand and collapse objects and folders so that you can navigate to the object you want to monitor or manage. Examples of objects are master groups, materialized view groups, materialized views, materialized view logs, deployment templates, and so on.< /li>
• Right-click a folder or object to create a new object or perform operations on a n existing object

Oracle completely redesigned the navigator tree structure in the Repl ication Management tool in a recent release. You begin many replication administration operations by selecting the correct object or folder in the navigator tree of the Replication Management tool.

Figure 7-2 Replication Management Tool Navigator Tree

Text description of the illustration reptree.gif

The following sections describe the contents of each object and folder in the tree structu re.

Administr ation Object

The Administration object enables you to manage the entir e replication site. Select the Administration object to display the following tabs in the right pane:

• Topology: Displays a graphical view of the replication environmen t for the selected site.
• Errors: Displays and lets you manage local errors at the selected site.
• Transactions : Displays and lets you manage the deferred transactions at the selected site.
• Schedule: Displays and lets you manage the push schedules for the database links at the selecte d site. Also, displays and lets you manage the purge schedule for successfully propagated deferred transactions at the selected site.
• Configuration: Displays and lets you manage confi guration information at the selected site, including initialization parameters important for replication and administrative requests.
• DBMS Jobs: Displays and lets you manage the jobs created with the DBMS_JOBS package. Many of these jobs perform important replication functions, such as pushing deferred transactions and purging the deferred transactions queue.

Multimaster Replication Object

< p class="BP">If your replication environment is configured for multimaster replication, then you use the Multimaster Replication obje ct to set up your master sites and manage your master groups. To set up master sites with the Setup Wizard, right-click the Multimast er Replication object and select Setup Master Sites.

Master Groups Folder

The Maste r Groups folder contains the master groups at the selected site. When you select a master group, you can:

• Start or stop (quiesce) the master group
• < /a>View and apply administrative requests for the master group
• Purge administrat ive requests for the master group
• Perform DDL operations on objects in the maste r group
• Manage the replicated objects in a master group
• Manage the replication sites participating in the master group

To create a new master group, right-click the Master Groups folder and select Create.

Materialized View Replication Object

The Materialized View Replication object lets you administer the replication site as it relates to materialized view replication. You can administer sites that are master sites of materialized view sites, and you can admi nister materialized view sites themselves. To set up master sites or materialized view sites with the Setup Wizard, right-click the M aterialized View Replication object and select Setup Sites.

The Materialized View Replication object contains the following objects:

• Master Site Object
• Materialized View Site Object

  Note: A replication site can be: A master site only, if it contains master groups but no materialized views. In this case, use the Master Site object to manage the site. A materialized view site only, if it contains materialized views but no master groups. In this case, use the Materialized View Site object to manage the site. Both a maste r site and a materialized view site, if it contains both master groups and materialized views. In this case, use both the Master Site object and the Materialized View Site object to manage the site.

Master Site Object

This object lets you manage the master groups at the replication site, and lets you ma nage sites that are master sites of materialized view sites. Specifically, this object lets you create, manage, and package deploymen t templates, and lets you create and manage materialized view logs. To set up master sites with the Setup Wizard, right-click the Mas ter Site object and select Setup Master Sites.

The Master Site object has the following folde rs:

• Master Groups Folder: This fol der provides the same functions as the Master Groups folder under the Multimaster Replication object. See the description of the Mast er Groups folder in "Multimaster Replication Object" for informatio n.
• Materialized View Logs Folder: This folder lets you create and manage materialized view logs at the master site. To create a new materialized view log, right-click the Materialized View Logs folder and select Create.
• Templates Folder: This folder lets you create, manage, and package deployment templates at the master site. Right-click the Templates folder and s elect:
  • Create Using Wizard if you want to create a new deployment template with the Deployment Template Wizard
  • Copy if you want to create a loc al or remote copy of a deployment template with the Copy Template Wizard
  • Compa re if you want to compare two local deployment templates
  • Template Script Gener ation if you want to package a deployment template for offline instantiation with the Template Script Generation Wizard

Materializ ed View Site Object

This object lets you manage materialized view site s. Specifically, this object lets you create and manage materialized view groups, materialized views, and refresh groups. To set up m aterialized view sites with the Setup Wizard, right-click the Materialized View Site object and select Setup Materialized View Sites.

The Materialized View Site object has the following folders:

• Materialized View Groups Folder: This folder lets you create and manage materialized view groups at the materialized view site. To create a new materialized view group with the Materialized View Gro up Wizard, right-click the Materialized View Groups folder and select Create Using Wizard.
• Materialized Views Folder: This folder lets you create and manage individual materialized vi ews at the materialized view site. To create a new materialized view, right-click the Materialized Views folder and select Create.
• Refresh Groups Folder: This folder lets you create a nd manage refresh groups at the materialized view site. To create a new refresh group, right-click the Refresh Groups folder and sele ct Create.

Right Pane

The right pane of the Replication Management tool enabl es you to monitor and manage your replication environment. Figure 7-3 shows an example of the G eneral tab in the Master Group property sheet.

Figure 7-3 Example Property Sheet

Text description of the illustration propshee.gif

When you are working with a property sheet, you may click a button that opens a dialog box. For example, if you click the Vi ew Administrative Request button on the General property sheet for a master group, then the Administrative Requests dialog box appear s, as shown in Figure 7-4.

Figure 7-4 Example Dialog Box

Text description of the illustration adminreq.gif

Topology Tab

You can use the right pane of the Replication Management tool to monitor your replicati on environment. The Topology tab of the Administration property sheet is an example of a monitoring tool that is available to you. Th is tab displays a graphical representation of the nodes in your replication environment and the links between them.

Specifically, the Topology tab provides the following information:

• All of the master sites participating in replication activity for the master groups of the selected site
• The number of deferred transactions at each master site
• The destination site for deferred transactions
• The nu mber of administrative requests at each master site
• Whether local errors exist a t a master site and the number of errors
• The total number of the materialized vi ews or materialized view groups connected to the selected master site
• Whether th e master site is also functioning as a materialized view site

The Topology tab only dis plays values if they are greater than zero. For example, if there are zero administrative requests at a master site, then the number of administrative requests is not displayed. If you are connected to a replication site that is running Oracle9i or higher, then the Topology tab also displays a Statistics button. Click this button to view performance statistics for the repl ication site.

Note: If you have not created at least one master group, materialized view group, or materialized view at the sel ected site, the Topology tab displays a message stating that replication must be configured.

The Topology tab displays the following icons and images:

Icon/Image	Description
Text description of the illustration master.gif	Indicates a master site.
Text description of the illustration adminrea.gif	Shows the current number of administrative requests being processed at the site with which it is associated.
Text description of the illustration masterer.gi f	Indicates a master site with deferred transaction errors or a dministrative request errors or both.
Text description of the illustration deftran.gif	Shows the curr ent number of deferred transactions to be applied at the site to which the associated arrow is pointing.
Text description of the illustration error_de.gif	Shows the number of deferred transaction errors at the site with which it is associated.
< img src="hybrid.gif" alt="Text description of hybrid.gif follows."> Text description of the illu stration hybrid.gif	Indicates a site that is functioning as bot h a master site and a materialized view site (a dual site).
Text description of the illustration hybrider.gif	Indicates a dual site with deferred transaction errors or administrative request errors or both.
Text description of the illustration regsnapg.gif	When you are connected to a master site, indicates that the master site has materialized view sites. Materialized views or materialized view groups or both may be registered at the master site.
Text description of the illustration snapshot. gif	When you are connected to a materialized view site, indicat es the materialized view site.
Text description of the illustration snapshoa.gif	Indicates a mater ialized view site with errors.
Text description of the illustration blackarr.gif (Solid black arrow)	Indicates a working database link from the cu rrent master site to the remote master site. Note: The Replicati on Management tool does not test the database link at the remote site. Therefore, the database link from the remote site to the curre nt site may be working or broken. To find out, connect to the remote site in the Oracle Enterprise Manager Console and view the Topol ogy tab.
Text description of the illustration redarrow.gif (Dashed red arrow)	Indicates a broken database link from the current master site to the remote master site. Note: If you are not logged in as the repli cation administrator (typically repadmin user), then a database link may appear broken even though the link is working n ormally between the two sites. The link appears broken because the current user does not have a private database link between the sit es, while the replication administrator does have a private database link. In this case, log in to the site as the replication admini strator to see if the link is broken.
Text description of the illustration blkarrw2.gif (One way black arrow)	When you are connected to a material ized view site, indicates a database link between the materialized view site and a master site. There may or may not be a network con nection currently between the two sites.
Text description of the illustration blackdot.gif (Dashed black line)	Indicates one or more database link s between materialized view sites and a master site. There may or may not be a network connection currently between the sites.

Figure 7-5 Example Topolog y Tab in the Replication Management Tool

Text description of the illustration topology.gif

When connected to the master database orc1.world, this example Topology tab provides the following inform ation:

• The databases orc1.world and orc2.worl d are master sites in the same replication environment.
• The database orc1.world is functioning only as a master site and not as a materialized view site, based on the icon for the database. The other master database (orc2.world) may be functioning only as a master site, or it may be functioning as a dual site. T o find out, you can connect to orc2.world.
• The master database orc1.world has two administrative requests to process.
• The master datab ase orc1.world has no local deferred transaction errors and no local administrative request errors.
• The master database orc2.world has no administrative requests to process.
• The master database orc2.world has no local deferred transaction errors and no l ocal administrative request errors.
• The master database orc1.world has eight deferred transactions in its deferred transaction queue that will be applied at orc2.world.
• The master database orc2.world has three deferred transactions in its deferred transa ction queue that will be applied at orc1.world.
• The master database orc1.world is the master site for one registered materialized view group and 15 registered materialized views. These re gistered materialized views may be spread over several materialized view sites.

The oth er master databases in this replication environment may also have materialized view sites, but they are only visible on the Topology tab when you are connected to those other databases. For example, to see if the master database orc2.world has any mater ialized view sites, connect to the orc2.world database in the Oracle Enterprise Manager Console and open the Topology ta b.

The Replic ation Management Tool Wizards

The Replication Management tool wizards provide step-by-step guidance for tasks that require many steps. The wizards simplify complex tasks by guiding you through the task i n manageable steps. The following sections describe the Replication Management tool wizards:

• Setup Wizard
• Materialized View Group Wizard
• Deployment Template Wizard
• Template Script Generation Wizard
• Copy Template Wizard

Setup Wizard

The Setup Wizard guides you through setting up master sites and materialized view sites for replication. Preparing sites for replic ation is a simple process using the Setup Wizard. At each site that you specify, the Setup Wizard performs the following steps:

< ul class="LB1">

Creates a database account to serve as a replication administrator. B y default, the Setup Wizard creates this account to serve also as the replication propagator and receiver. The default username for t he replication administrator at a master site is repadmin, and the default username at a materialized view site is mvadmin. However, you can change these usernames if you wish.

Grants the necessary privileges to the replication administrator account.

Creates database links to correspond to new replication administrator accounts at each replication site.

For master sites and optionally for materialized view sites, schedules a job to push changes from the master site to each ot her master site.

Schedules a job to purge the deferred transaction queue of comp leted transactions for all sites in the system.

The Setup Wizard is slightly different for master sites than for materialized view sites. To open the Setup Wizard to set up master sites, right-click the Multimaster Repli cation object in the navigator pane and select Setup Master Sites.

Figure 7-6 Opening Screen of Setup Wizard for Master Sites

Text description of the illustration rms etmas.gif

See Also: The "Setup Master Sites: Overview" topic in the Replication Management tool online help for detai led information about using the Setup Wizard to set up a master site. To access this topic in the online help, open Replication > Set Up Replication Sites > Master Site in the Help Contents.

To open the Setup Wizard to set up materialized view sites, right-click the Materialized View Site object in the navigator pane and s elect Setup Materialized View Sites.

Note: The Setup Wizard sets up materialized view sites with untrusted security. Oracle Database Advanced Replication Managem ent API Reference for more information about untrusted security.

Figure 7-7 Opening Screen of Setup Wizard for Materialized View Sites

Text description of the illustration rmsetsna.gif

See Also: The "Set Up Materialized View Sites: Overview" top ic in the Replication Management tool online help for detailed information about using the Setup Wizard to set up a materialized view site. To access this topic in the online help, open Replication > Set Up Replication Sites > Materialized View Site in the Hel p Contents.

See Also: Chapter 2, "Master Replication Concepts and Architecture" for more information about master sites Chapter 3, "Materialized View Concepts and Architecture" for more information about materialized view sites.

Materialized View Group Wizard

The Materialized View Group Wizard guides you through creating a group of materialized views based on a master g roup. Each materialized view can be a partial or complete copy of the master tables in its source master group. Materialized view gro ups are located at remote materialized view sites and are based on a single, target master group at a master site.

Run the Materialized View Group Wizard at the materialized view site where you want to create the materialized view group. To open the Materialized View Group Wizard, right-click the Materialized View Groups folder in the navigator pane and sel ect Create Using Wizard.

Figure 7-8 Opening Sc reen of the Materialized View Group Wizard

Text description of the illustration rmsnapgr.gif

See Also: T he "Create Materialized View Group: Overview" topic in the Replication Management tool online help for detailed information about usi ng the Materialized View Group Wizard to create a materialized view group. To access this topic in the online help, open Replication > Materialized View Replication > Create in the Help Contents.

See Also: "Materializ ed View Groups" for more information about materialized view groups

Deployment Templ ate Wizard

Deployment templates simplify the task of deploying and mai ntaining many remote materialized view sites. Using deployment templates, you can define a collection of materialized view definition s at a master site and use parameters in these definitions to customize the materialized views for individual users or types of users .

For example, you might create one template for the sales force and another template for fie ld service representatives. In this case, a parameter value might be the sales territory or the customer support level. When a user i nstantiates a template by running a SQL script, the appropriate materialized views are created and populated at the remote site.

The Deployment Template Wizard guides you through creating a deployment template. Individual scre ens in the Deployment Template Wizard let you:

• Name the deployme nt template and specify whether it is public or private. If it is private, then you can specify authorized users.
• Add objects to the deployment template
• Specify parameters for the deployment template

Run the Deployment Template Wizard from the mas ter site where you want to create the deployment template. To open the deployment template wizard, right-click the Templates folder i n the navigator pane and select Create Using Wizard.

Figure 7-9 Opening Screen of the Deployment Template Wizard

Text description of the illustration rmdeptmp.gif

See Also: The "Overview of Creating a Deployment Template" topic in the Replication Management tool online help for deta iled information about using the Deployment Template Wizard to create a deployment template. To access this topic in the online help, open Replication > Deployment Templates > Create in the Help Contents.

See Also: Chapter 4, "Deployment Templates Concepts and Architecture" for more information about deployment temp lates

Template Script Generation Wizard

Offline instantiati on allows an end user to use a generated file to instantiate a template without being connected to the master site through a network. The Template Script Generation Wizard enables you to write all of the necessary DDL and data to a file that you then transfer and ru n at your materialized view site. This solution is best suited for laptop users with low-speed WAN connections, or in other cases whe re connectivity is unstable or slow.

The Template Script Generation Wizard guides you through packaging a deployment template for offline instantiation. The Template Script Generation Wizard generates offline instantiation fil es that you use to build materialized views and other objects at your materialized view sites.

Run the Template Script Generation Wizard at the master site that contains the template for which you want to generate the offline instantiation files. To run the Template Script Generation Wizard, right-click the Templates folder in the navigator pane and select Template Script Generation.

Figure 7-10 Openin g Screen of the Template Script Generation Wizard

Text description of the illustration rmoffins.gif

Note: To g enerate online instantiation files, you must use the replication management API. See Oracle Database Advanced Replication Management API Reference for informat ion about generating online instantiation files.

See Also: The "Package for Offline Instanti ation: Overview" topic in the Replication Management tool online help for detailed information about using the Template Script Genera tion Wizard to package a deployment template for offline instantiation. To access this topic in the online help, open Replication > ; Deployment Templates > Packaging and Instantiation in the Help Contents.

See Also: "Packaging and Instantiation Process" for more information on packaging and instantiating deployment templates

Copy Template Wizard

The Copy Template Wizard guides you through copying a deployment template. You may need to copy them to multiple master s ites for various reasons. For example, you may want to:

• Distribute network load: Before allowing users to instantiate the template, you need to locate the template at the master site of the target materialized view sites. If you have a large network, then you may want to copy the template definition to multiple master sites, thereby distributing the network load of multiple materialized view sites.
• Make changes to a template: After building a template, you may need to create ano ther template that has many of the same characteristics of the first template. Instead of building an entirely new template, copy the template and modify it as necessary.

Run the Copy Template Wizard from the master site that contains the deployment template. To open the Copy Template Wizard, right-click the Templates folder in the navigator pane and select Copy.

Figure 7-11 Copy Template Wizard< /em>

Text description of the illustration rmcpytmp.gif

See Also: The "Copying a Template" topic in the Replic ation Management tool online help for detailed information about using the Copy Template Wizard to copy a deployment template. To acc ess this topic in the online help, open Replication > Deployment Templates > Manage in the Help Contents.

Flowchart for Creating a Replication Environment

The flowchart in Figure 7-12 displays the major decisions and tasks that are involved when you create a replication environmen t using the Replication Management tool. The flowchart shows the major decisions and steps for building both multimaster and material ized view environments. Each task in the flowchart includes a cross reference to a section in this book that provides more informatio n about the task. Detailed instructions about completing these tasks are in the Replication Management tool online help.

Figure 7-12 Create a Replication Environment Using the Re plication Management Tool

Text description of the illustration repln084.gif