Setting up the Target Database as the new Source
You can use the Target Database when the Source database is lost. The following section describes the steps to setup the Target Database as the new Source:
1. If the Source node installation is working:
a. Disconnect all database users.
b. Manually execute --jnlsync process, this will sync targets with source.
2. Designate one of the targets as the new source and execute --incremental_done on the selected target.
ingresSync --target=target-host --database=syncdb --installID=II --incremental_done
This will disable INCR_RFP state and make the database available for updates (the designated target is now the source).
3. Checkpoint the new Source database.
4. Once the failed instance is functional, it is brought into the group as a target.
Execute the --ckpsync --restart process, this will sync the new target database with the source and place the target database in the required INCR_RFP state
When using --ckpsync --restart command, the source and target nodes must be specified explicitly with the --source --target flags. This is required to define the source and target nodes as this cannot always be determined from the database status flags. For incremental synchronization, with --jnlsync the hosts can be specified individually with --source --target or a comma separated list with --hosts.
The preferred method is to use --hosts since it determines the host roles dynamically and performs the sync in the correct direction. This allows the scheduled journal sync job to execute unchanged even if source and target roles are changed. The journal sync (--jnlsync) job can be executed either on the source or target.
Last modified date: 08/29/2024