Restart After Planned Shutdown
We recommend 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 afterwards.
To restart a node, execute this command: adastart <dbid>.
1. The last node that was stopped should be started first usingadastart <dbid>.
2. To identify the last node that was stopped, compare the seqno value in the grastate.dat file of each node (see $ADADATADIR/dbxxx/grastate.dat).
3. The node with the largest seqno value is the last node stopped and should contain safe_to_bootstrap: 1 in grastate.dat file.
Every end of transaction or status change (e.g. start/stop nodes) of the cluster increases the value of seqno.
4. Start bootstrap node:
a. Start node, if safe_to_bootstrap: 1 setting found in grastate.dat and CLUSTER_URL for this node is not set currently.
b. Set environment variable CLUSTER_BOOTSTRAP=1 before restarting the node.
5. Start secondary node(s):
a. Check valid CLUSTER_URL setting in dbini file.
b. Start secondary node(s).
CLUSTER_BOOTSTRAP should be unset!