Identifying the Databases in the Active Standby Pair

The first component identifies the active master database, standby master database, and any subscriber databases. The first database name designates the active master database. The second database name designates the standby master database. Read-only subscriber databases are indicated by the SUBSCRIBER clause.

Use the full database name described in Defining the DSNs for the Databases.

CREATE ACTIVE STANDBY PAIR master1, master2
        SUBSCRIBER subscriber1;

The active master database and the standby master database should be on separate hosts to achieve a highly available system. Read-only subscribers can be either local or remote. A remote subscriber provides protection from site-specific disasters.

You can also specify the hosts where the databases reside by using an IP address or a literal host name surrounded by double quotes. Provide a host ID as part of FullDatabaseName:

DatabaseName [ON Host]

Host can be either an IP address or a literal host name. Use the value returned by the hostname operating system command. It is good practice to surround a host name with double quotes. For example:

CREATE ACTIVE STANDBY PAIR 
   repdb1 ON "host1", 
   repdb2 ON "host2";