Show TOC

hss_addstandbyLocate this document in the navigation structure

Use

Use this command to create a standby database within a hot standby system.

When you execute this command, the registry entry for the new standby database with the specified name is created on the specified node. The standby database is configured on the basis of the configuration of the master database and then transferred to the ADMIN operational state.

Recommendation

To facilitate the administration of the hot standby system, create a standby database with the same name as the master database on a different database computer. For testing purposes only, a standby database of a different name can be added on the same computer where the master database is located.

Prerequisites

  • You are connected to the master database on the virtual server.

  • The standby database do be created does not exist yet.

  • You have the server permission ParamFull.

Structure

hss_addstandby [node=]<computer_name> login=<os_user>,<os_user_password> [path=<installation_path>] [delay=<hs_delay_time>] [user=<user_mode>] [database=<database_name>])

Option

Description

<computer_name>

Computer name or IP address of the standby database

Specify a computer name different from the master database computer to use the safety benefits of a hot standby system.

<os_user>

Operating system user on the standby computer,

requires administration rights for the computer

<os_user_password>

Password of the operating system user

<installation_path>

Installation path of the version-dependent database server software on the standby computer

If you do not specify a path, the system uses the database software version of the master database.

<hs_delay_time>

Only relevant for the high availibility mode based on a shared log area:

Time delay (in seconds) with which the standby database is to be updated after a log page was written in the master database.

<user_mode>

Relevant on Windows only:

Specify the value YES to add the operating system user to the service entry.

<database_name>

Name of the standby database

We recommend that you specify the same name as the master database.
Result

OK

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, log on to the database DEMODB on the HOTEL_VIRTUAL virtual server as the operator OLEG with the password MONDAY, add a standby database on the computer PARMA specifying the operating system user ANNA with the password MAY for that computer:

> dbmcli -u OLEG,MONDAY -d DEMODB -n HOTEL_VIRTUAL hss_addstandby PARMA login=ANNA,MAY

OK

More Information