| Table of Contents |
|---|
이중화 전체 현황
...
| Code Block |
|---|
set linesize 1024
set colsize 20
SELECT a.replication_name rep_name
, d.host_ip || decode(d.host_ip, b.peer_ip, ' (*)', NULL) peer_ip
, nvl(to_char(e.rep_gap), '-') as rep_gap
, a.xsn restart_xsn
, decode(b.peer_port, NULL, 'OFF', 'ON') as sender
, decode(c.peer_port, NULL, 'OFF', 'ON') as receiver
FROM system_.sys_repl_hosts_ d
, system_.sys_replications_ a
left outer join v$repsender b on a.replication_name = b.rep_name
left outer join v$repreceiver c on a.replication_name = c.rep_name
left outer join
(select rep_name, max(rep_gap) rep_gap from v$repgap group by rep_name) e
on a.replication_name = e.rep_name
WHERE a.replication_name = d.replication_name
ORDER BY rep_name;
REP_NAME PEER_IP REP_GAP RESTART_XSN SENDER RECEIVER
----------------------------------------------------------------------------------------------------------------
REP 192.168.1.149 (*) 0 9668 ON ON |
...
이중화의 이름, ip, SENDER, RECEIVER의 상태를 확인할 수 있습니다.
이중화 sender 정보
...
| Code Block |
|---|
set linesize 1024
set colsize 20
SELECT trim(REP_NAME) as REP_NAME
, decode(START_FLAG, 0, 'Normal',
1, 'Quick',
2, 'Sync',
3, 'Sync Only') as START_FLAG
, decode(net_error_flag, 0, 'OK', 'Error') as NET_ERROR_FLAG
, decode(STATUS, 0, 'Stop', 1, 'Run', 2, 'Retry') as STATUS
, peer_ip
, peer_port
, XSN
FROM V$REPSENDER;
REP_NAME START_FLAG NET_ERROR_FLAG STATUS PEER_IP PEER_PORT XSN
-------------------------------------------------------------------------------------------------------------------------
REP Normal OK Run 192.168.1.149 30300 9675 |
...
이중화 SENDER의 원격서버의 IP, PORT, network 에러 여부, 상태 등을 확인할 수 있습니다.
이중화 receiver 정보
...
| Code Block |
|---|
set linesize 1024
set colsize 20
SELECT trim(REP_NAME)
, trim(MY_IP)
, trim(PEER_IP)
, MY_PORT
, PEER_PORT
, apply_xsn
FROM X$REPRECEIVER;
TRIM(REP_NAME) TRIM(MY_IP) TRIM(PEER_IP) MY_PORT PEER_PORT APPLY_XSN
----------------------------------------------------------------------------------------------------------------------
REP 192.168.1.145 192.168.1.149 30300 26722 13461585 |
...
이중화 RECEIVER의 원격서버의 IP, PORT 등을 확인할 수 있습니다.
이중화 gap
...
| Code Block |
|---|
set linesize 1024
set colsize 20
select rep_name
, rep_gap
from v$repgap;
REP_NAME REP_GAP
----------------------------------------------
REP 0 |
...