Restart After Planned Shutdown
Software AG recommends that you always back up your database before performing any changes to the cluster, even if you do not plan to restore the backup data afterward.
By default, the node you start first becomes the primary node of the cluster. A cluster is gracefully shut down when all nodes are stopped using adastop or utility command adaopr [can-cel, shutdown]. Usually, the last stopped node becomes the next primary.
To identify which node was last stopped and has the highest sequence number (seqno), compare either the value of seqno of each node in $ADADATADIR/dbxxx/grastate.dat or execute the following command: adanuc dbid=dbid noplog options=autorestart_only.
The node with the largest seqno value is the node last stopped and should contain safe_to_bootstrap: 1 in the grastate.dat file.
To restart a cluster after a planned shutdown:
Start a bootstrap node:
Start node, if safe_to_bootstrap: 1 setting found in grastate.dat file.
Start secondary node(s):
Check valid CLUSTER_URL setting in dbini file and restart secondary node(s).
Note:
Please remember, if CLUSTER_BOOTSTRAP is set (via command export CLUSTER_BOOTSTRAP= or part of topic NUCPARMS in DB.INI-file), any CLUSTER_URL setting will be ignored during startup!