Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

 

Overall status of replication


Column description

Column nameDescription
restart_xsnSN reflected by the remote server that is the target of replication, and the starting point for retransmission when the replication is restarted
senderWhether the sender is running or not
receiverWhether the receiver is running or not

The name of the replication, IP, sender status, and receiver status can also be checked.

Replication sender information


Column description

Column nameDescription
rep_nameName of replication object
peer_ipIP address of the replication target remote server
peer_portPort number of the replication target remote server
StatusIt is normal when the current state of sender is 1. / STOP(0), RUN(1), RETRY(2)
repl_modesender's current replication mode / lazy, eager
NET_ERROR_FLAGnetwork 에러 여부로 0이어야 정상이다. / OK(0), ERROR(1)
XSNsender가 마지막으로 송신한 SN(Serial Number/리두로그일련번호)으로 v$repgap의 REP_SN과 동일

The IP, port, network error, and status of the replication sender's remote server can also be checked.

 

Replication receiver information


Column description

Column nameDescription
peer_ipIP address of the remote server as the subject of replication
peer_portPort number of the remote server that is the subject of replication
apply_xsnSN of the remote server currently being reflected by the receiver

The IP and port of the remote server of the replication receiver can be checked.

 

Replication gap


Column description

Column nameDescription
rep_nameName of replication
rep_gapThe degree of unsynchronization is indicated by the interval between rep_last_sn and rep_sn. (I.e. rep_last_sn-rep_sn)

If the replication gap is increased by a lot, there are things to check.

  1. Check the network status (operation, failure, if IP or port is blocked by firewall, etc.)
  2. Check the remote requirement status (hardware failure, remote DB shutdown, etc.)
  3. Check the BULK DML operation

In the above case, the replication gap may increase, so it is necessary to check the above cases.

 

 

  • No labels