A DBA with an HADR setup with three-member clusters (members
0, 1, and 2) issues the MON_GET_HADR table function from the primary
to query the state of the HADR databases on all members:
select LOG_STREAM_ID, PRIMARY_MEMBER, STANDBY_MEMBER, HADR_STATE, HADR_FLAGS
from table (mon_get_hadr(-2))
The following information
is returned:
LOG_STREAM_ID PRIMARY_MEMBER STANDBY_MEMBER HADR_STATE HADR_FLAGS
------------- -------------- -------------- -------------- -----------------------
0 0 0 PEER
1 0 0 REMOTE_CATCHUP ASSISTED_REMOTE_CATCHUP
2 2 0 PEER
3 record(s) selected.
This output indicates that member
1 is in assisted remote catchup state and that member 0 is the assisting
member. If the DBA issues the table function with a member argument
of member 1, the result is as follows:
select LOG_STREAM_ID, PRIMARY_MEMBER, STANDBY_MEMBER, HADR_STATE, HADR_FLAGS
from table (mon_get_hadr(1))
LOG_STREAM_ID PRIMARY_MEMBER STANDBY_MEMBER HADR_STATE HADR_FLAGS
------------- -------------- -------------- -------------- ----------
1 1 0 DISCONNECTED