Hi,
I'm new with OpenEdge database, so please correct me if I'm wrong in some items.
Since it's 3 month that I joined team, and didn't have yet enough experience with OpenEdge, I'll be very appreciate to your help guys with my problem.
What we have :
2 Nodes - source/target
OpenEdge edition - 11.7
OS - CentOS 7.8
Replication mode - async
In our projects we have a 3 TB database with previously enabled replication by vendor DBA's, so all source/target config files for replication available without any changes. AI files with archiving enabled on the source DB.
Last week we lost our replication database, since main active DB extent file became corrupted. DB size already was 3 TB at replication crashing time, obviously AI files on source become LOCKED, and since we have only daily full backup of DB and don't have incremental backups for quick restoring target database, we decided to disable replication on source, to release back locked AI files in source database, because source database must be available 24/7.
I've a task to restore replication from this database from the scratch. Currently we observe exponential growth of DB, ~ 200 GB per week.
We have a NFS share between source/target DB with 10GB NIC.
Below I created row plan how to restore replication, can anyone help me is this plan is ok? I concern about facing issue with source AI while restoring target, to prevent AI files become again in "Locked" mode.
-- on source db
probkup online $db /mnt/store/progressdb/$db-repl.bk
proutil $db -C enablesitereplication source
probkup online $db incremental /mnt/store/progressdb/$db-repl-inc.bk -com -REPLTargetCreation
dsrutil /db1/$db/$db -C restart server
-- on target db
prorest $db /mnt/store/progressdb/$db-repl.bk
prorest $db /mnt/store/progressdb/$db-repl-inc.bk -REPLTransition
/opt/local/bin/dbup_slave.sh /db1/$db/$db
I'm new with OpenEdge database, so please correct me if I'm wrong in some items.
Since it's 3 month that I joined team, and didn't have yet enough experience with OpenEdge, I'll be very appreciate to your help guys with my problem.
What we have :
2 Nodes - source/target
OpenEdge edition - 11.7
OS - CentOS 7.8
Replication mode - async
In our projects we have a 3 TB database with previously enabled replication by vendor DBA's, so all source/target config files for replication available without any changes. AI files with archiving enabled on the source DB.
Last week we lost our replication database, since main active DB extent file became corrupted. DB size already was 3 TB at replication crashing time, obviously AI files on source become LOCKED, and since we have only daily full backup of DB and don't have incremental backups for quick restoring target database, we decided to disable replication on source, to release back locked AI files in source database, because source database must be available 24/7.
I've a task to restore replication from this database from the scratch. Currently we observe exponential growth of DB, ~ 200 GB per week.
We have a NFS share between source/target DB with 10GB NIC.
Below I created row plan how to restore replication, can anyone help me is this plan is ok? I concern about facing issue with source AI while restoring target, to prevent AI files become again in "Locked" mode.
-- on source db
probkup online $db /mnt/store/progressdb/$db-repl.bk
proutil $db -C enablesitereplication source
probkup online $db incremental /mnt/store/progressdb/$db-repl-inc.bk -com -REPLTargetCreation
dsrutil /db1/$db/$db -C restart server
-- on target db
prorest $db /mnt/store/progressdb/$db-repl.bk
prorest $db /mnt/store/progressdb/$db-repl-inc.bk -REPLTransition
/opt/local/bin/dbup_slave.sh /db1/$db/$db