Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Overview of the ON-Bar Backup and Restore System > Restoring Data with ON-Bar > Transferring Data with the Imported Restore >

Initializing High-Availability Data Replication with ON-Bar (IDS)

Follow the steps for the imported restore first and then start HDR and perform a physical-only restore on the target computer. Also see Initializing HDR with an External Backup and Restore (IDS).

Important:
If you use ON–Bar to perform the backup and restore, ontape is required on both database servers. You cannot remove ontape from database servers participating in HDR.
To perform the imported restore
  1. Follow the steps in ***.
  2. On the source computer, add entries into your sqlhosts file or registry to recognize the target instance.

    Verify that the source and target database servers can communicate over the network. For more information on sqlhosts, see the IBM Informix: Administrator's Guide.

  3. Follow the steps in ***.
  4. Copy the emergency boot files, oncfg files, ONCONFIG file, and storage-manager files from the source computer to the target computer.
To initialize High-Availability Data Replication
  1. To start HDR on the source database server, use the following command: 
    onmode -d primary secondary_dbservername

    You might see the following messages in the database server message log:

    19:28:15  DR: new type = primary, secondary server name = solo_724
19:28:15  DR: Trying to connect to secondary server ...
19:28:18  DR: Primary server connected
19:28:18  DR: Receive error
19:28:18  DR: Failure recovery error (2)
19:28:19  DR: Turned off on primary server
19:28:20  Checkpoint Completed: duration was 0 seconds.
19:28:20  DR: Cannot connect to secondary server
19:28:31  DR: Primary server connected
19:28:31  DR: Receive error
19:28:31  DR: Failure recovery error (2)
19:28:32  DR: Turned off on primary server
19:28:33  Checkpoint Completed: duration was 0 seconds.
19:28:33  DR: Cannot connect to secondary server
  2. Perform a physical-only restore on the target computer. 
    onbar -r -p

    If you performed a whole-system backup (onbar -b -w), you could optionally use onbar -r -w -p to restore the storage spaces only.

  3. Check the database server message log, ON–Bar activity log, and the storage-manager error log to see whether the restore was successful.
  4. To start HDR on the target database server, use the following command: 
    onmode -d secondary primary_dbservername
  5. If the logical logs needed to synchronize the two database servers are still present on the source database server, the target server retrieves them from the source database server.
  6. While the database servers are synchronizing, the logical logs are transferred automatically from the source to the target server.
  7. If the logical logs are not on the source database server, you are prompted to restore the required logical logs. If the target database server requires a log number that no longer exists because it was overwritten, ON–Bar will need to retrieve that logical log from the backup.

The following online.log messages might display while the database servers are synchronizing: 

19:37:10  DR: Server type incompatible
19:37:23  DR: Server type incompatible
19:37:31  DR: new type = secondary, primary server name = bostonserver
19:37:31  DR: Trying to connect to primary server ...
19:37:36  DR: Secondary server connected
19:37:36  DR: Failure recovery from disk in progress ...
19:37:37  Logical Recovery Started.
19:37:37  Start Logical Recovery - Start Log 11, End Log ?
19:37:37  Starting Log Position - 11 0x629c
19:37:44  Checkpoint Completed:  duration was 0 seconds.
19:37:45  Checkpoint Completed:  duration was 0 seconds.

19:37:47  Checkpoint Completed:  duration was 0 seconds.
19:37:48  DR: Secondary server operational
19:37:49  Checkpoint Completed:  duration was 0 seconds.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]