Show TOC

Setting Up a Hot Standby System (With Shared Log Area)Locate this document in the navigation structure

Prerequisites

  • You have set up a cluster consisting of the computers on which the master database and the standby databases will be located, and you have set up a storage system.

    For more information about the prerequisites for setting up a hot standby system, see Database Administration, Hot Standby System (With Shared Log Area)

  • Create the database that will later become the master database.

    With the following database parameters, you configure the later behavior of the hot standby system:

    • HotStandbySyncInterval

      At regular intervals, the master database informs the standby databases of the position in the log area up to which it has written new log entries to the shared log area. To configure this interval, use the special database parameter.

    • HotStandbyDelayTime?

      The system regularly updates the standby databases by performing redo operations using the log entries from the shared log area. Thus the content of the standby database always corresponds to the content of the master database, though with a certain delay.

    For more information about creating databases, see Creating Databases.

Context

In this hot standby solution, master database and standby databases share a single log area. You can set up several standby databases. This solution is suitable for large databases with lots of data changes.

Note though that you need a storage system.

Procedure

  1. In the context menu of the database that will become the master database, choose Start of the navigation path Administration Tasks Next navigation step Hot Standby System Next navigation step Configure... End of the navigation path.
  2. To enable the hot standby system:

    1. Enter the virtual server name of your cluster.

      Note that the virtual server name must not be the same as the name of a computer in the cluster.

    2. As type of hot standby system, choose Shared Log Area.

    3. As storage DLL, enter the name of the library that is used to address the storage system.

  3. Select Start Standby Database.
  4. To finish the setup of the hot standby system, choose Activate.

Next Steps

Setting Up Hot Standby Systems: Overview

Database Administration, Hot Standby System (With Shared Log Area)

Database Manager CLI, Setting Up a Hot Standby System (With Shared Log Area)