Entering content frame

Procedure documentation Setting Up a Hot Standby System Locate the document in its SAP Library structure

Use

You set up a hot standby system to increase the availability of your database system. To do so, you need a suitable memory management system and a cluster solution.

Refer to the manufacturer's documentation for information about setting up a memory management system and cluster configuration.

See also:

Architecture of a Hot Standby System

 

Overview of the Commands for Setting Up a Hot Standby System

Action

Syntax

Displaying the Hot Standby Parameters

hss_getnodes

Executing DBM Commands on a Standby Component

hss_execute

Defining the database instance as a master component

hss_enable

Defining a standby component

hss_addstandby

Deleting a Standby Component

hss_removestandby

Prerequisites

·        Master and standby components use the same hardware with the same memory capacity and same type and number of processors.

·        All the paths and file names of the database instance (run directory, volumes, trace files, and so on) are identical for the master and standby components.

·        The same database software version is installed on all computers.

·        All the computers are switched on.

·        The X server is running on all these computers.

·        You have administrator rights on all these computers.

Procedure

Eröffnen einer Verbindung mit der im Cluster als Master definierten Komponente...

       1.      Connect to the cluster server:
dbmcli -n <virtual_server_name>

       2.      Create a database instance

       3.      Transfer the database instance to the OFFLINE operational state

       4.      Define the database instance as a master component

       5.      Transfer the Database Instance to the Operational State ONLINE

       6.      Define an Additional Standby Component

       7.      Transfer the standby component to the STANDBY operational state, whereby the configuration of the master components is copied to the standby component

Result

The hot standby system is set up. To add further standby components, repeat steps 6 and 7.

Example

Setting up a hot standby system with the name HOTELDB with a master component GENUA and a standby component PARMA,

the hot standby system is assigned the virtual serer name HOTEL_VIRTUAL,

DAVID with the password BLUE has the rights of an operating system user on the servers GENUA and PARMA

This graphic is explained in the accompanying text

The procedure defined above results in the following steps:

...

       1.      Connect to the cluster server:
dbmcli -n HOTEL_VIRTUAL

  2.      Create the database instance HOTELDB and the DBM operator DBM with password DBM while specifying the operating system user DAVID with password BLUE for the remote server:
db_create HOTELDB DBM,DBM DAVID,BLUE

Transfer the HOTELDB database instance to the ADMIN operational state:
db_admin

Activate the database instance:
db_activate DBA,DBA

Load the system tables:
load_systab -ud dba

  3.      Transfer to the OFFLINE operational state:
db_offline

       4.      Define the new database instance as a master component:
hss_enable node=HOTEL_VIRTUAL lib=LIBHSSCOPY

       5.      Transfer to the ONLINE operational state:
db_online

       6.      Define the standby component PARMA:
hss_addstandby PARMA login=ANNA,MAY

       7.      Transfer the standby component to the STANDBY operational state:
db_standby PARMA

 

 

 

Leaving content frame