onmode -d: Set data-replication types
>>-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:
onmode -d standard
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.