integrated extract 구성

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