Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)FrançaisItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Use Database Replication

Get started

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Introduction to OpenEdge Replication
    • What is data replication
      • Key features of OpenEdge Replication
      • How OpenEdge Replication works with two databases
      • How OpenEdge Replication works with a replication set
      • How OpenEdge Replication works with Transport Layer Security
    • OpenEdge Replication terminology
      • Primary and secondary databases
      • Source and target databases
        • The source database
        • The target database
        • Other source and target database characteristics
          • Target quiet points
          • Schema lock
      • A Replication Set
      • OpenEdge Replication property files
      • OpenEdge Replication server
      • OpenEdge Replication agent
        • Designate a critical agent
        • Enhanced Read-Only mode
      • OpenEdge Replication Model
      • Failover
      • Failback
      • Transition
    • Source and target architecture requirements
    • OpenEdge Replication activity during normal processing
      • Normal source database activity
      • Normal target database activity
    • What happens if there is a database failure
      • Choose a hot standby database
      • Synchronization between server and agent
        • If the server detects a communication failure with the agent
        • If the agent detects a communication failure with the server
    • OpenEdge Replication utilities and commands
  • OpenEdge Replication and After-imaging
    • Understand OpenEdge Replication after-image requirements
    • Calculate current database after-image volume
      • Use after-image VST information
      • Use the RFUTIL command
      • Use the PROMON command
      • Use before-image VST information
    • The role of after-image extents in the Replication process
      • After-image extent types
      • After-image extent states
      • After-image extent sizing on a source database
      • Calculate fixed after-image extent size
        • After-image extent sizing based on hourly data
        • After-image extent sizing based on weekly data
        • Use variable extents
      • After-image interdependency between source and target databases
    • Determine OpenEdge Replication network bandwidth
      • Estimating network bandwidth
      • Anticipating additional network overhead
    • Ensure success when using after-imaging
    • OpenEdge Replication and after-imaging: a summary
  • Plan for OpenEdge Replication
    • Preliminary planning tasks
      • Step 1: Review after-image information
      • Step 2: Create a database backup plan
      • Step 3: Evaluate your production database
      • Step 4: Determine if you will be replicating an encryption-enabled database
        • Replication process for databases enabled for encryption
    • Understand the importance of after-imaging in OpenEdge Replication planning
      • Determine acceptable latency
      • Determine acceptable target database downtime
      • Determine appropriate failover behavior
      • Understand limitations and restrictions
  • Set Up OpenEdge Replication
    • Overview
      • Get started
        • Choose an online or an offline backup of the source database
        • Choose the OpenEdge Replication agent startup mode
    • Set up the OpenEdge Replication databases
      • Set up the source database with an offline backup
        • Step 1: Back up the source database
        • Step 2: Create a structure file
        • Step 3: Enable database after-imaging
          • Enable AI on your source database
        • Step 4: Enable the source database for OpenEdge Replication
        • Step 5: Perform an incremental backup of the source database
        • Step 6: Where to go next
      • Set up the source database with an online backup
        • Step 1: Create a structure file
        • Step 2: Enable the database for after-imaging
          • Enable after-imaging on your source database
        • Step 3: Enable the source database for OpenEdge Replication
        • Step 4: Perform an online backup
        • Step 5: Configure the OpenEdge Replication server for deferred agent startup
        • Step 6: Where to go next
      • Set up the OpenEdge Replication target database
        • Create the OpenEdge Replication target database
      • Enable before-image encryption for a Replication-enabled target database
    • Configure the OpenEdge Replication property files
      • Sample OpenEdge Replication property files
        • Sample OpenEdge Replication source property file
        • Sample OpenEdge Replication target properties file
        • Sample OpenEdge Replication combined properties file
      • Server properties
      • Control agent properties
      • Agent properties
      • TLS properties
      • Logging level for Replication
      • Configure the source database property file
        • Properties file example
        • Agent rules in the source replication properties file
      • Configure the target database property file
        • Properties file example
      • Connect-timeout property
    • Choose the OpenEdge Replication agent startup mode
      • Use the immediate agent startup mode
      • Use the deferred agent startup mode
      • Set up the deferred agent startup implementation
    • Start OpenEdge Replication
      • Message logging during startup
      • Start the source database
      • Start the target database
      • OpenEdge Replication startup and initialization process
      • Start OpenEdge Replication with the DBMAN utility or OpenEdge Explorer
      • Database connection considerations
    • Access a running replication-enabled database
      • Access a target database
        • User connections during key store changes
      • Access a source database
    • Enable transparent data encryption for an OpenEdge Replication-enabled source database
      • Enable encryption for a Replication-enabled source database that is online
    • Stop OpenEdge Replication
      • Enforce source and target database synchronization during shutdown
      • Validate synchronization at shutdown
      • Shut down the source database
      • Shut down the target database
      • Terminate the OpenEdge Replication server when the source database is running
      • Terminate the OpenEdge Replication agent when the target database is running
      • Disable OpenEdge Replication on the server
      • Disable OpenEdge Replication on the agent
  • Move From Failure to Recovery with OpenEdge Replication
    • Overview of database failure recovery
      • Automated transition functions
    • Possible types of failure
      • Detect TCP/IP communications failures
      • Source failure recovery after losing connection
      • Target transition after losing connection
    • Restore a source database
    • Transition
      • Transition scenarios
      • Intuitive transition processing
      • JTA transactions and transition
      • Configure transition
        • Choose either one or two target databases
        • Set up automatic transition
        • Set up manual transition
      • Plan for transition
      • Failover transition
        • After-imaging on target databases during online failover transition
        • Failover transition and offline backup
        • Automatic restart and online failover transition
        • Alternate Buffer Pool and online failover transition
        • Rolling upgrade support during online failover transition
        • Online Manual Recovery Transition
      • Transition End Trigger
    • OpenEdge Replication from normal activity through failure and recovery
      • Step 1: Primary replication before a failure
      • Step 2: Primary machine failure
      • Step 3: Enter pretransition
        • Manually apply after-image extents
      • Step 4: Transition the target database to a source database
      • Step 5: Failover
      • Step 6: Primary machine repair complete
      • Step 7: Initiate primary database transition
      • Step 8: Secondary replication is performed
      • Step 9: The Replication failback process
        • Failback processing using transition failover
        • Advantages and disadvantages of using transition failover to perform failback
        • Failback processing using controlled transition
        • Initiate failback with controlled transition
        • Advantages and disadvantages of performing failback with controlled transition
    • Transition of a Replication Set
    • Recovery from transition failures
    • Transition logging
    • Transition properties
      • Set transition properties
    • Sample of a startup parameter file used by transition
      • Source database startup parameter file
      • Target database startup parameter file
      • Normal database startup parameter file
    • Transition property reference
      • Transition command actions
      • Transition properties summary
  • Enable Replication AI Streaming
    • Replication AI Streaming Overview
    • Configure Replication AI Streaming
    • Observe Replication AI Streaming in the Replication Monitor
    • Observe Replication AI Streaming in VSTs
    • Understand automatic transition with AI Streaming
  • Reference
    • DSRUTIL utility
    • DSRUTIL applyextent qualifier
    • DSRUTIL canceldefer server qualifier
    • DSRUTIL connectagent database qualifier
    • DSRUTIL disablesitereplication qualifier
    • DSRUTIL monitor qualifier
    • DSRUTIL recovery qualifier
    • DSRUTIL restart agent qualifier
    • DSRUTIL restart server qualifier
    • DSRUTIL startagent database qualifier
    • DSRUTIL status qualifier
      • Detail or verbose return codes
      • Status only return codes
    • DSRUTIL terminate qualifier
    • DSRUTIL transition qualifier
    • DSRUTIL transition failover qualifier
    • DSRUTIL triggertransition qualifier
    • DSRUTIL verify qualifier
    • OpenEdge Replication DSRUTIL MONITOR
      • Startup menu
      • Monitor latency between the source and target databases
        • From the OpenEdge Replication server perspective
        • From the OpenEdge Replication agent perspective
      • Replication server status
      • Replication server remote agents
      • Replication remote agents status
      • Replication agent status
      • Replication inter-agent status
    • Virtual system tables for OpenEdge Replication
      • _Repl-Server VST field descriptions
      • _Repl-Agent VST field descriptions
      • _Repl-AgentActivity VST field descriptions
      • _Repl-AgentControl VST field descriptions
      • _Repl-AgentControlActivity VST field descriptions
      • _Repl-AgentAIStreaming VST field descriptions
      • _DbServiceManager VST field descriptions
      • _DbServiceManagerObjects VST field descriptions
        • Database service object statuses
      • _DbStatus VST field descriptions
      • _Repl-InterAgentActivity VST field descriptions
      • Modifiable VSTs on Replication Targets
    • Utilities and OpenEdge Replication
    • OpenEdge Replication and database management systems
    • DSRUTIL logginglevel qualifier
  • OpenEdge Replication Quick Command Summary
    • Configuring the OpenEdge Replication property files
    • Setting up the source and target databases
      • Setting up the source database with deferred agent startup for online backup
      • Set up the target database
    • Enabling before-image encryption for a Replication-enabled target database
    • Configuring OpenEdge Replication with deferred agent startup
    • Configuring OpenEdge Replication for one agent
    • Configuring OpenEdge Replication for two agents
    • Starting OpenEdge Replication
    • Stopping OpenEdge Replication
    • Terminating the OpenEdge Replication server and agent
    • Configuring for automatic transition
    • Configuring for manual transition
    • Using manual transition
    • Re-enabling OpenEdge Replication after transition
    • Restarting the OpenEdge Replication server after target shutdown
    • Monitoring an OpenEdge Replication database
    • Backing up an online target database
Table of Contents

Get started

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: January 17, 2024
  • 1 minute read
    • OpenEdge
    • Version 12.8
    • Documentation

Before you can set up OpenEdge Replication, you must consider the following factors:

  • Whether you plan to use an online or an offline backup of the source database to create the target database
  • The mode you plan to use to start the agent on the target database
Contents
  • Choose an online or an offline backup of the source database
  • Choose the OpenEdge Replication agent startup mode
TitleResults for “How to create a CRG?”Also Available inAlert