Changing the logging mode of databases

You cannot turn on transaction logging for databases on the primary database server while you are using HDR. You can turn logging off for a database; however, subsequent changes to that database are not duplicated on the secondary database server.

To turn on database logging:

  1. To turn HDR off, shut down the secondary database server.
  2. Turn on database logging.

    After you turn on logging for a database, if you start data replication without performing the level-0 backup on the primary database server and restore on the secondary database server, the database on the primary and secondary database servers might have different data. This situation might cause data-replication problems.

  3. Perform a level-0 backup on the primary database server and restore on the secondary database server. This procedure is described in Starting HDR for the First Time.

Copyright© 2018 HCL Technologies Limited