ORACLE/이중화(HA)
integrated extract 구성
argoLee
2019. 10. 18. 17:13
1. integrated extract 구조
2. integrated extract views
1) gv$goldengate_capture
2) v$logmnr_session
3) v$logmnr_stats
4) dba_xstream_outbound_progress, gv$xstream_outbound_server
3. 구성 절차
1) 스트림풀 설정
ALTER SYSTEM SET streams_pool_size=5000M;
2) 권한 설정
BEGIN
dbms_goldengate_auth.grant_admin_privilege
(
grantee => 'ogg',
privilege_type => 'CAPTURE',
grant_select_privileges => TRUE
);
END;
/
3) 등록
DBLOGIN USERID ogg PASSWORD ogg
REGISTER EXTRACT ext1 DATABASE
4) 시작
ADD EXTRACT ext1 INTEGRATED TRANLOG, BEGIN NOW
start ext1