Show TOC

db_standbyLocate this document in the navigation structure

Use

Use this command to add a standby database to the hot standby system and transfer it to the STANDBY operational state.

During this process, an exact copy of the configuration of the master database is imported into the standby database.

If you create a hot standby system on the basis of twofold log writing, also all data of the master database are copied to the standby database. For that purpose, the database software calls a copy tool, which copies the complete data of the master database to the data area of the standby database. Simultaneously all log entries written in the master database will start to be also written to the standby database.

Prerequisites

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

  • You have the server permission DBStart.

  • For the hot standby system (with shared log area), all the data paths and files (run directory, volumes, trace files, and so on) are the same in the master database and the standby database. The master database must be in the OFFLINE operational state.

Structure

db_standby [node=]<computer_name> [database=<database_name>] [network_port=<number>] [template=<backup_template>]

Option

Description

<computer_name>

Computer name, IP address, or internal number <nnn> of the standby database ( nnn> 1)

<database_name>

Name of the standby database

<number>

Network port number to be used

<backup_template>

Name of the backup template to be used
Result

OK

In the event of errors, see Reply Format.

More Information