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

Set up the OpenEdge Replication databases

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

Set up the OpenEdge Replication databases

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

You can use either an online or an offline backup of the source database to create the target database.

Contents
  • Set up the source database with an offline backup
  • Set up the source database with an online backup
  • Set up the OpenEdge Replication target database
  • Enable before-image encryption for a Replication-enabled target database
TitleResults for “How to create a CRG?”Also Available inAlert