Kbase P125583: How to add a second target database to an extablished source/target configuration.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2010 |
|
Status: Verified
GOAL:
How to add a second target database to an established source/target configuration without stopping the source database.
GOAL:
Can a second target database be created while another target is already running
GOAL:
Can a second target database be created while another target is already exists
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.1E
Fathom Replication
FIX:
Yes. It is possible to create a second target database while another target is already running, but the first target database and the replication server must be restarted.
To create a second target database without stopping the source database follow the steps below:
1. Check that there are empty ai files, if not, some must be made available before continuing.
2. Backup the source database using the following command.
probkup online <db-name-source> <device-name> -REPLTargetCreation
3. prorest <sec-target-db-name> <probackup file created in setp 2> <if-needed-.st file for sec-target-db>
4. Enable database for target replication
proutil <sec-target-db-name> -C enableSiteReplication target
5. Create a file called <sec-target-db-name>.repl.properties file by copying from target.repl.properties located at $DLC/properties and save it in the directory for the second target database.
6. Edit <sec-target-db-name>.repl.properties and change the "name" at the [agent] section from agent1 to agent2.
7. Stop the first target database using proshut -by command.
proshut <first-target-db-name> -by
8. Stop the replication server using the dsrutil command.
dsrutil <source> -C terminate server
9. Edit current <source-db-name>.repl.properties file and make thhe following changes:
a) add the agent2 to the "control-agent" at the [server] section.
b) add a new [control-agent.agent2] section by copying [control-agent.agent1] section.
c) make all the appropriate changes to each parameter to the new [control-agent.agent2] section such as the name from agent1 to agent2.
Finnish by saving those changes.
10. Start both target databases.
11. Restart replication server.
dsrutil <source> -C restart server