Identifies an available secondary link to the standby database.
Applicable to: Master database
Required or Optional: Optional
Default Value: None
The Alt_Remote_Node qualifier is used to provide the master
database with uninterrupted hot standby replication in case of
network failure where multiple network links are available. It
can only be used in conjunction with the Standby_Root qualifier,
which specifies the standby database node name.
The Alt_Remote_Node qualifier identifies the alternate remote
node name of the standby database. Following network failure,
the master database automatically attempts to reconnect to
the standby database using the alternate remote node name
information. If the Alt_Remote_Node qualifier is not specified,
the master database does not automatically attempt to reconnect
to the standby database using the orginal remote node name
specified using the Standby_Root qualifier.
The alternate node name can be the same as the node name
specified with the Standby_Root qualifier. The node name
specified by the Alt_Remote_Node qualifier must identify the
same standby database on the same remote node as originally
specified using the Standby_Root qualifier. The maximum length
of the alternate remote node name is 31 characters.
At run-time, the RDM$BIND_HOT_NETWORK_ALT_NODE logical name
can be defined in the LNM$SYSTEM_TABLE table to override any
alternate remote node name information specified at hot standby
startup. The logical must be specified on all nodes where the
master database is open.
The RMU Replicate After_Journal Configure/Reset command clears
previously configured alternate remote node name information.