Kbase P125677: What are the steps to enable OpenEdge Replication on a live database on OpenEdge 10.1B or later
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/06/2010 |
|
Status: Verified
GOAL:
What are the steps to enable OpenEdge Replication on a live database on OpenEdge 10.1B or later
GOAL:
How to set up Fathom Replication on a live database without having to take it off line using OpenEdge 10.1B or newer.
GOAL:
How to enable OpenEdge Replication on a live database the quickest way
GOAL:
How to set up Fathom Replication on a live database without downtime
GOAL:
How to enable replication on a database?
GOAL:
How to set up replication on a database?
GOAL:
How to configure replication on a database?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2x
FIX:
The ability to enable Replication online started in 10.1A, with the stipulation that after imaging had already been enabled on the database, however, this requirement has been dropped in 10.1B.
On the Source Side:
1. Copy source.repl.properties from $DLC/properties to the directory where the source database is located (same directory where the .db is located) and rename it to be <source
dbname>.repl.properties
Edit this file providing the correct information for the configuration and any additional parameters like, defer-agent-startup, that my be desired.
2. If After-imaging is already enabled on the source database go to step 5. If not, add Ai extents online with the command after preparing the .st file ai extents:
prostrct addonline <dbname> <add-st-file-name>
3. Enable After imaging online using one of the following commands:
If aiarchiver is not being used:
probkup online <dbname> <output-device> enableai
If ai archiver is to be used the following command may be used:
probkup online <dbname> <output-device> enableai enableaiarchiver -aiarcdir <directory-path> -aiarcinterval <desired-interval-in-seconds>
4. To enable AIWs:
proaiw dbname
5. Enable the database for source replication;
proutil <dbname> -C enableSiteReplication source
6. Backup the source database is needed to create the target database. An online backup requires the -REPLTargetCreation parameter to do this.
probkup online <dbname> <device-name> -REPLTargetCreation
On the Target Side:
7. Copy target.repl.properties from $DLC/properties to the directory where the target will be located (same directory where the target .db will be located) and rename it to be <target
dbname>.repl.properties
Edit the file as needed.
8. The target is created by restoring the backup created in step 5:
prorest <target-dbname> <device-file-name>
9. Replication on the target database is enabled with the following command:
proutil <dbname> -C enableSiteReplication target
10. Start the target database and agent
proserve <dbname> -DBService replagent -S 4501
On the Source Side:
11. Start Replication server on source database:
dsrutil <dbname> -C restart server
NOTE: These are a simplified steps as it did not define multiple brokers/servers which may also be done.
Follow the rules and guidelines provided in the OpenEdge Replication Users Guide.