onmode -d: Set data-replication types

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onmode-- -d--+-standard----------------+--------------------><
                '-+-primary---+--ha_alias-'   
                  '-secondary-'               

Element Purpose Key Considerations
-d Used to set a server's data-replication type. You can use the -d standard option when the database server is in quiescent, online, or read-only mode.
ha_alias Identifies the high-availability alias of the primary or secondary database server. The high-availability alias is the server's HA_ALIAS configuration parameter value.

The ha_alias argument of the other database server in the data-replication pair and the database server's type (standard, primary, or secondary) is preserved after reinitialization of shared memory.

Using the -d standard option

The -d standard option drops the connection between database servers in a data replication pair (if one exists) and sets the database server type of the current database server to standard. This option does not change the mode or type of the other database server in the pair.

Use the onmode -d standard command only to disconnect a primary server from an HDR secondary server. Running the command converts the HDR secondary server to a standalone server. You should not run the onmode -d standard command to disconnect a primary server from an RS secondary server. To disconnect a primary server from an RS secondary server run the following commands:

On the RS secondary server:
onmode -d standard
On the primary server:
onmode -d delete RSS rss_ha_alias

Using the -d primary option

The -d primary option sets the database server type to primary and attempts to connect with the database server that dbservername specifies. If the connection is successful, data replication is turned on. The primary database server goes into online mode, and the secondary database server goes into read-only mode. If the connection is not successful, the database server is in online mode, but data replication is not turned on.

Using the -d secondary option

The -d secondary option sets the database server type to secondary and attempts to connect with the database server that ha_alias specifies. If the connection is successful, data replication is turned on. If the primary database server goes online, and the secondary database server goes into read-only mode. If the connection is not successful, the database server is in read-only mode, but data replication is not turned on.

This command has an equivalent SQL administration API function.


Copyright© 2019 HCL Technologies Limited