Kbase P104741: How to set up Fathom Replication on a live database with minimum downtime in OpenEdge 10.0x
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/20/2009 |
|
Status: Unverified
GOAL:
How to set up Fathom Replication on a live database with minimum downtime
GOAL:
How to reestablish OpenEdge Replication on a live database the quickest way
FACT(s) (Environment):
OpenEdge 10.0x
FIX:
We assume you have a database without AI up and running.
On the Source Side:
- Do a online backup
PROBKUP online dbname <device>
- Shut down the database
PROSHUT dbname -by
- Remove dbname.repl.recovery file (if it exist)
- Add the AI extents to and .st file and create the AI extents
PROSTRCT add dbname add_ai.st
- Mark database as backed up
RFUTIL dbname -C mark backedup
- Activate the After Image
RFUTIL dbname -C aimage begin
- Enable replication
PROUTIL dbname -C enableSiteReplication source
- Copy and modify the dbname.repl.properties from
$DLC/properties/source.repl.properties
- Add the defer agent startup to the dbname.repl.properties file in the [server] section
defer-agent-startup=1
- Start the source Database
PROSERVE dbname <dbparams> -DBService replserv
- Do a Full online backup with the target creation parameter
PROBKUP online dbname <device> -REPLTargetCreation
- Move the backup to the remote site
Use RCP,FTP ,etc...
On the Target Side :
- Restore the Backup
PROREST dbname <device>
- Remove dbname.repl.recovery file (if it exist)
- Enable target replication
PROUTIL dbname -C enableSiteReplication target
- Copy and modify the dbname.repl.properties from
$DLC/properties/target.repl.properties
- Start the database (Target database should be started first)
PROSERVE dbname <dbparams> -DBService replagent -S port
The port needs to be the same as the port parameter in the Fathom Replication server?s repl.properties file.
On the Source Side:
- Restart the replication server
DSRUTIL dbname -C restart server
Test and monitor the replication environment.