The Duplica Repository set-up wizard starts automatically if you are installing Duplica for the first time and have just created a new user. When you set-up the Duplica Repository you must choose the type of installation that you require. If you are installing Duplica for the first time you should choose the install option. In time, once you have already loaded Duplica, you will commonly be using the Upgrade, Re-create/Overwrite or rebuild options.
The Duplica Repository can also be accessed from the Set-up button on the screen or in the Duplica main menu.
A database link should be created between the 'Duplica owner' at the target database and the user/schema at the source database who owns the data to be replicated. If these were not already created you can create them using Duplica. Also you can edit and delete an existent database link.
A suite is a group of tables that will be replicated. The tables are grouped together because they are intimately related (i.e. parent - child table relationships through primary keys and foreign keys) or the tables are required, as a group, for further processing by the employees at the target database.
You can choose which suites will be replicate.
First of all, is needed to schedule selected suite(s) to replicate by clicking on the "schedule" button.
The START button will start the Replication control mechanism. If you start the control mechanism all scheduled jobs will begin replicating. All paused and scheduled jobs will start automatically.
When the process of replication is turned on, suites in the "scheduled" state will begin replicating. Their state will then change to "running".
Replication Monitor is used to monitor run time replication and target database resources. It is basically a series of views that accurately portray the state of the database and the performance of data replication.
- Errors view shows errors that are related to Live Database and General Replication Errors relate to the health of the database.
- Scheduled to run next view lists the suites that are currently scheduled to run.
- Currently running view shows some runtime statistics on suites that are currently running.
- Latest Run Performance views show the performance statistics for the most recent run for each suite that has been replicated. Shows performance statistics for the most recent run for each table.
- Latest Run Logs views are an Audit log, which displays all replication events that have taken place since the last time the table was purged (deleted) and an Error log, which displays a complete list of the replication errors.
- Tablespace Checks view contains four sub-views.
- Tablespace view shows the amount of free space in each of the tablespaces in the database.
- Free Space Graph illustrates the data displayed in the Tablespaces view.
- Objects About to Crash view shows the objects, which are having trouble creating a next extent.
- Tables To Rebuild shows the tables, which require indexing.
- Replication Audit Log view shows displays all replication events that have taken place.
- Replication Error Log view shows all the errors that have occurred during the replication process.