Show TOC

Procedure documentationSetting Up a Hot Standby System (No Shared Resources) Locate this document in the navigation structure

 

In this hot standby solution, master database and standby database share no system resources. Log entries are written simultaneously to the log area of the master database and the log area of the standby database.

For this hot standby solution, you do not need a special storage system.

Note that you can only set up one standby database. Since the log entries are transported to the standby database over a normal network connection, this solution is not suitable for very large databases with lots of data changes

Prerequisites

  • You have set up a cluster consisting of the two database computers on which the master database and the standby database will be located.

    For more information on the prerequisites for setting up a hot standby system, see Database Administration, Hot Standby System (No Shared Resources).

  • Create the database that will later become the master database. You can also use an existing SAP MaxDB database.

    Caution Caution

    When creating the volumes of the master database, use relative paths.

    End of the caution.

    Recommendation Recommendation

    Set the parameter EnableMultipleServerTaskUKT to YES (see Database Administration, Support Database Parameters). This may significantly speed up the redo operations in the standby database in the hot standby system.

    End of the recommendation.

    For more information about creating databases, see Creating Databases.

  • In the master database, you have defined a backup template for a complete data backup (see Defining Backup Templates).

    Note Note

    You cannot use backup templates of the type PIPE.

    End of the note.

Procedure

Configuring a Hot Standby System

  1. In the context menu of the database that will become the master database, choose   Administration Tasks   Hot Standby System   Configure...  .

  2. To enable the hot standby system:

    1. Enter the virtual server name of your cluster.

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

  3. To create the standby database, enter the following data:

    Standby Database: Properties

    Property

    Description

    Computer Name

    Name of the computer on which the standby database is to be created

    Database Name

    Name of the standby database

    Recommendation Recommendation

    Use the same name for master and standby database.

    End of the recommendation.

    Login Name

    Name of the operating system user for accessing the standby database computer

    Password

    Password of the operating system user for accessing the standby database computer

    Use this login for the database service of the standby database

    Only for network shares on Microsoft Windows

    Depending on your system setup, select this option so that all users have the correct permissions.

    Installation

    Database software installation

    Caution Caution

    The database software versions of the installations for the master database and the standby database must be identical.

    End of the caution.

  4. To start the standby database:

    1. Choose Start Standby Database.

    2. Enter a free network port. This port will be used for copying the redo log entries from the master to the standby database.

    3. Select the backup template that you have created in the master database.

  5. To finish the setup of the hot standby system, choose Activate.

    The hot standby system is activated and added to the explorer tree as Hot Standby System node with the master database and standby database as sub-nodes.

    Caution Caution

    To execute commands in the hot standby system, from now on always use the commands that are available in the context menu of the Hot Standby System node in the explorer tree.

    End of the caution.

    Recommendation Recommendation

    To make it easier to see which database currently has which role in the hot standby system, choose   Window   Preferences   Database Studio   Label Decorations   and select Hot Standby. This adds labels to the icons in the explorer tree.

    End of the recommendation.
Stopping and Starting the Standby Database

  • To stop the standby database, choose   Administration Tasks   Hot Standby System   Stop Standby Database...   in the context menu of the Hot Standby System node in the explorer tree.

    Note that stopping the standby database interrupts the log shipping.

  • To start the standby database, choose   Administration Tasks   Hot Standby System   Start Standby Database...   in the context menu of the Hot Standby System node in the explorer tree, enter a network port and choose a backup template for the initial data copy. Then choose Start.

    Note that starting the standby database will take some time because a new initial data backup will be restored in the standby database.

Deleting a Standby Database

The hot standby system always consists of one master database and one standby database.

If you want to substitute the current standby database by a new one, you first have to delete the current standby database by choosing   Administration Tasks   Hot Standby System   Delete Standby Database...   in the context menu of the Hot Standby System node in the explorer tree.

Adding a Standby Database

The hot standby system always consists of one master database and one standby database. If you have removed the former standby database, you can add a new standby database as follows:

In the context menu of the Hot Standby System node in the explorer tree, choose   Administration Tasks   Hot Standby System   Add Standby Database...   and proceed as described in the section Configuring a Hot Standby System.

Disabling the Hot Standby System

After removing the standby database, you can remove all hot standby properties from the master database by choosing   Administration Tasks   Hot Standby System   Disable...   in the context menu of the Hot Standby System node in the explorer tree.

More Information

Setting Up Hot Standby Systems: Overview

Database Administration, Hot Standby System (No Shared Resources)

Database Manager CLI, Setting Up a Hot Standby System (No Shared Resources)