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

출처: https://semode.tistory.com/325?category=663959 [세모데]