{"id":1001,"date":"2015-12-31T01:08:40","date_gmt":"2015-12-31T01:08:40","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1001"},"modified":"2015-12-31T01:08:40","modified_gmt":"2015-12-31T01:08:40","slug":"oracle-streams-configure","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1001","title":{"rendered":"ORACLE STREAMS CONFIGURE"},"content":{"rendered":"

1.ORACLE STREAMS CONFIGURE<\/SPAN> <\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H1>
\n

1.1 <\/SPAN><\/SPAN><\/FONT><\/A>\uc0ac\uc804 \uc124\uc815<\/SPAN><\/FONT><\/SPAN><\/H2>
\n

1.1.1 <\/SPAN><\/SPAN>Parameter <\/SPAN><\/FONT><\/A>\uc124\uc815 (9i <\/SPAN>\uae30\uc900)<\/SPAN><\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

\uc0ac\uc804 \uc791\uc5c5\uc73c\ub85c \uc544\ub798\uc758 \ud30c\ub77c\ubbf8\ud130\uac12 \ub4e4\uc744 \uc124\uc815\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/SPAN><\/FONT><\/SPAN><\/B><\/P>
\n

(9i <\/SPAN>\uae30\uc900, 11g <\/SPAN>\uc758 \uacbd\uc6b0 \ubcc0\uacbd\ub418\uac70\ub098 \uae30\ubcf8\uac12\uc73c\ub85c \uc9c0\uc815\ub418\uc5b4 \ud2b9\ubcc4\ud788 \uc9c0\uc815\ud574 \uc8fc\uc9c0 \uc54a\uc544\ub3c4 \uac00\ub2a5)<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

AQ_TM_PROCESSES=2 <\/FONT><\/SPAN><\/B><\/P>
\n

1<\/SPAN>\uc774\ub098 1<\/SPAN>\uc774\uc0c1\uc758 \uac12\uc744 \uc9c0\uc815\ud55c\ub2e4. <\/SPAN>\uc774\ub294 capture<\/SPAN>\uc5d0 \uc758\ud574 capturing<\/SPAN>\ub41c lcr<\/SPAN>\uc758 propagation<\/SPAN>\ud560 \ub54c <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc0ac\uc6a9\ud558\ub294 queue<\/SPAN>\uc758 agent <\/SPAN>\uc218\ub97c \ub098\ud0c0\ub0b8\ub2e4.  <\/SPAN><\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

ARCHIVE_LAG_TARGET=1800 <\/FONT><\/SPAN><\/B><\/P>
\n

      <\/SPAN>RAC<\/SPAN>\ud658\uacbd\uc5d0\uc11c, Capture process<\/SPAN>\uac00 Online Redo log<\/SPAN>\ub97c \ubc14\ub85c \uc77d\uc9c0 \ubabb\ud558\uace0(9i) <\/SPAN>\uc591\ucabd <\/SPAN><\/SPAN><\/FONT><\/P>
\n

node<\/SPAN>\uc758 archive file<\/SPAN>\uc744 \uc77d\uc5b4\uc57c \ud558\ub294\ub370, <\/SPAN>\uc77c\ubc18\uc801\uc73c\ub85c archive file<\/SPAN>\uc740 redo log file<\/SPAN>\uc758 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\ud06c\uae30\ub9cc\ud07c \uc4f0\uc5ec \uc838\uc57c\ub9cc log switch<\/SPAN>\uac00 \ubc1c\uc0dd\ud558\uba74\uc11c archive file<\/SPAN>\uc774 \uc0dd\uc131\ub41c\ub2e4. <\/SPAN>\uadf8\ub7ec\ub098 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Stream<\/SPAN>\uc5d0\uc11c\ub294 archive file<\/SPAN>\uc744 \uc0dd\uc131\ud558\ub294 \uac83\uc744 Log Switch<\/SPAN>\uac00 \ubc1c\uc0dd\ud560 \ub54c \uc0dd\uc131\ub418\ub294 \uac83 \uc678\uc5d0 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc77c\uc815\ud55c \uc2dc\uac04\uc73c\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. <\/SPAN>\uc774\ub54c \uc0ac\uc6a9\ud558\ub294 parameter<\/SPAN>\ub85c \ucd08 \ub2e8\uc704\ub85c \uc9c0\uc815\ud560 \uc218 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uc788\ub2e4. <\/SPAN>\ub9cc\uc57d 30<\/SPAN>\ubd84 \ub9c8\ub2e4 archive file<\/SPAN>\uc744 \uc0dd\uc131\ud558\uc5ec \ubcc0\uacbd\uc744 capture<\/SPAN>\ud558\uae30 \uc704\ud574\uc11c\ub294 1800<\/SPAN>\uc73c\ub85c <\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uc9c0\uc815\ud558\uba74 \ub41c\ub2e4.<\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

COMPATIBLE=9.2.0  <\/SPAN><\/FONT><\/SPAN><\/B><\/P>
\n

  <\/SPAN>Stream<\/SPAN>\uc740 9iR2<\/SPAN>\uc5d0\uc11c \uc0c8\ub85c \ub098\uc628 \uae30\ub2a5\uc774\ubbc0\ub85c compatible<\/SPAN>\uc744 9.2 <\/SPAN>\uc774\uc0c1\uc73c\ub85c \uc9c0\uc815\ud574\uc57c <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\ud55c\ub2e4.  <\/SPAN><\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

GLOBAL_NAMES=TRUE <\/FONT><\/SPAN><\/B><\/P>
\n

distribute database<\/SPAN>\ub97c \uc0ac\uc6a9 \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294, network <\/SPAN>\uc0c1\uc758 \uc720\uc77c\ud55c database <\/SPAN><\/SPAN><\/FONT><\/P>
\n

connection<\/SPAN>\uc744 \uc720\uc9c0 \ud558\uae30 \uc704\ud574 \uc624\ub77c\ud074\uc5d0\uc11c\ub294 db link<\/SPAN>\ub97c \uc0dd\uc131\ud560 \ub54c Database Link<\/SPAN>\uc758 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc774\ub984\uc744 Remote Database<\/SPAN>\uc758 global_name<\/SPAN>\uc73c\ub85c \ub9cc\ub4e4\ub3c4\ub85d \uc81c\uc57d\uc744 \uac00\ud558\ub294\ub370, <\/SPAN>\uc774\ub7ec\ud55c <\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uc81c\uc57d\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud55c parameter. <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

JOB_QUEUE_PROCESSES=2 <\/FONT><\/SPAN><\/B><\/P>
\n

job process<\/SPAN>\uc758 \uc218\ub97c \uacb0\uc815\ud558\ub294 parameter<\/SPAN>\ub85c, queue<\/SPAN>\uc640 queue<\/SPAN>\ub85c \uc804\ub2ec\ud558\ub294 \uc9c1\uc811\uc801\uc778 \uc77c\uc744 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\ud558\ub294 \ud504\ub85c\uc138\uc2a4\uac00 \ub41c\ub2e4. 1<\/SPAN>\uc774\uc0c1\uc758 \uac12\uc744 \uc9c0\uc815\ud55c\ub2e4. (Max 999) <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

LOG_PARALLELISM=1 <\/FONT><\/SPAN><\/B><\/P>
\n

  <\/SPAN>Capture process<\/SPAN>\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ubc18\ub4dc\uc2dc 1<\/SPAN>\ub85c \uc9c0\uc815. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

LOGMNR_MAX_PERSISTENT_SESSIONS=10 <\/FONT><\/SPAN><\/B><\/P>
\n

log miner<\/SPAN>\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ub3d9\uc2dc session<\/SPAN>\uc758 \uc218\ub97c \uc9c0\uc815\ud558\uac8c \ub418\ub294\ub370, <\/SPAN>\uc774 session<\/SPAN>\uc740 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

persistent<\/SPAN>\ud558\uac8c \uc720\uc9c0\ub418\uba70 \ud604\uc7ac\uc758 \uc815\ubcf4\ub97c dictionary<\/SPAN>\uc5d0 \ubcf4\uc874\ud55c\ub2e4.  <\/SPAN><\/SPAN>\ub9cc\uc57d capture<\/SPAN>\ub97c \uc5ec\ub7ec \uac1c <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc6b4\uc601\ud558\uac8c \ub418\ub294 \uacbd\uc6b0\uc5d0\ub294, <\/SPAN>\ucd5c\uc18c\ud55c capture<\/SPAN>\uc758 \uc218\ubcf4\ub2e4 \ub354 \ub9ce\uc774 \uc9c0\uc815\ud55c\ub2e4. <\/SPAN>\ubcf4\ud1b5\uc758 \uad8c\uc7a5 \uac12\uc740 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

10<\/SPAN>\uc774\ub2e4. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

OPEN_LINKS=30 <\/FONT><\/SPAN><\/B><\/P>
\n

source<\/SPAN>\uc640 target<\/SPAN>\uc758 \ub3d9\uc2dc db link<\/SPAN>\uc758 \uc5f0\uacb0 \uc218\ub97c \uc9c0\uc815\ud558\ub294 parameter<\/SPAN>\uc774\ub2e4. <\/SPAN>\ubcf4\ud1b5\uc758 \uacbd\uc6b0 30 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc815\ub3c4 \uc9c0\uc815\ud558\uba74 \ubb38\uc81c \uc5c6\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

PARALLEL_MAX_SERVERS=12 <\/FONT><\/SPAN><\/B><\/P>
\n

capture<\/SPAN>\ub098 apply <\/SPAN>\ud504\ub85c\uc138\uc2a4\uc5d0 \uc791\uc5c5\uc774 \ub9ce\uc744 \uacbd\uc6b0\uc5d0\ub294 \uac01\uac01 parallel<\/SPAN>\ud558\uac8c \uc791\uc5c5\uc744 \uc218\ud589 \ud560 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc218 \uc788\uc73c\uba70,   <\/SPAN>Capture<\/SPAN>\uc640 apply<\/SPAN>\uc758 property<\/SPAN>\uc5d0 parallel <\/SPAN>\uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4.   <\/SPAN><\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uadf8\ub7ec\ubbc0\ub85c database level<\/SPAN>\uc5d0\uc11c \uad00\uc7a5\ud558\ub294 paralell_max_servers<\/SPAN>\uc218\ub294 capture, apply<\/SPAN>\uc758 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

parallelism<\/SPAN>\uc744 \ud5c8\uc6a9\ud560 \uc218 \uc788\ub294 \ub9cc\ud07c \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

LOGMNR_MAX_PERSISTENT_SESSIONS=10 <\/FONT><\/SPAN><\/B><\/P>
\n

log miner<\/SPAN>\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ub3d9\uc2dc session<\/SPAN>\uc758 \uc218\ub97c \uc9c0\uc815\ud558\uac8c \ub418\ub294\ub370, <\/SPAN>\uc774 session<\/SPAN>\uc740 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

persistent<\/SPAN>\ud558\uac8c \uc720\uc9c0\ub418\uba70 \ud604\uc7ac\uc758 \uc815\ubcf4\ub97c dictionary<\/SPAN>\uc5d0 \ubcf4\uc874\ud55c\ub2e4.  <\/SPAN><\/SPAN>\ub9cc\uc57d capture<\/SPAN>\ub97c \uc5ec\ub7ec \uac1c <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc6b4\uc601\ud558\uac8c \ub418\ub294 \uacbd\uc6b0\uc5d0\ub294, <\/SPAN>\ucd5c\uc18c\ud55c capture<\/SPAN>\uc758 \uc218\ubcf4\ub2e4 \ub354 \ub9ce\uc774 \uc9c0\uc815\ud55c\ub2e4. <\/SPAN>\ubcf4\ud1b5\uc758 \uad8c\uc7a5 \uac12\uc740 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

10<\/SPAN>\uc774\ub2e4. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

OPEN_LINKS=30 <\/FONT><\/SPAN><\/B><\/P>
\n

source<\/SPAN>\uc640 target<\/SPAN>\uc758 \ub3d9\uc2dc db link<\/SPAN>\uc758 \uc5f0\uacb0 \uc218\ub97c \uc9c0\uc815\ud558\ub294 parameter<\/SPAN>\uc774\ub2e4. <\/SPAN>\ubcf4\ud1b5\uc758 \uacbd\uc6b0 30 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc815\ub3c4 \uc9c0\uc815\ud558\uba74 \ubb38\uc81c \uc5c6\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

PARALLEL_MAX_SERVERS=12 <\/FONT><\/SPAN><\/B><\/P>
\n

capture<\/SPAN>\ub098 apply <\/SPAN>\ud504\ub85c\uc138\uc2a4\uc5d0 \uc791\uc5c5\uc774 \ub9ce\uc744 \uacbd\uc6b0\uc5d0\ub294 \uac01\uac01 parallel<\/SPAN>\ud558\uac8c \uc791\uc5c5\uc744 \uc218\ud589 \ud560 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc218 \uc788\uc73c\uba70,   <\/SPAN>Capture<\/SPAN>\uc640 apply<\/SPAN>\uc758 property<\/SPAN>\uc5d0 parallel <\/SPAN>\uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4.   <\/SPAN><\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uadf8\ub7ec\ubbc0\ub85c database level<\/SPAN>\uc5d0\uc11c \uad00\uc7a5\ud558\ub294 paralell_max_servers<\/SPAN>\uc218\ub294 capture, apply<\/SPAN>\uc758 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

parallelism<\/SPAN>\uc744 \ud5c8\uc6a9\ud560 \uc218 \uc788\ub294 \ub9cc\ud07c \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

TRANSACTION_AUDITING=TRUE <\/FONT><\/SPAN><\/B><\/P>
\n

DDL<\/SPAN>\uc5d0 \ub300\ud55c \ubcc0\uacbd\ub0b4\uc6a9\uc5d0 \ub300\ud55c \uc801\uc6a9\uc744 \uc815\ud655\ud558\uac8c \ud558\uae30 \uc704\ud574\uc11c \uc9c0\uc815. (Note:238458.1 <\/SPAN>\ucc38\uace0) <\/SPAN><\/SPAN><\/FONT><\/P>
\n

alert.log<\/SPAN>\uc5d0 \uc544\ub798\uc640 \uac19\uc740 error<\/SPAN>\uac00 \ubc1c\uc0dd \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ubc18\ub4dc\uc2dc \uc9c0\uc815\ud574\uc57c \ud568. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

WARNING: no base object information defined in logminer <\/FONT><\/SPAN><\/P>
\n

dictionary!!!   <\/SPAN><\/FONT><\/SPAN><\/P>
\n

knlldmm: gdbnm=SITE1.WORLD   <\/SPAN><\/FONT><\/SPAN><\/P>
\n

knlldmm: objn=6838   <\/SPAN><\/FONT><\/SPAN><\/P>
\n

knlldmm: objv=1   <\/SPAN><\/FONT><\/SPAN><\/P>
\n

knlldmm: scn=147467  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.2 <\/SPAN><\/SPAN>DB Level <\/SPAN><\/FONT><\/A>\uc758 \uc0ac\uc804 \uc791\uc5c5<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Archive Log Mode<\/SPAN><\/B>\ub85c \ubcc0\uacbd. <\/SPAN><\/SPAN><\/B><\/FONT><\/P>
\n

Capture <\/SPAN>\ud504\ub85c\uc138\uc2a4\ub294 \uc77c\ubc18\uc801\uc73c\ub85c Online Redo log<\/SPAN>\ub97c \uc77d\uc5b4\uc11c \ubcc0\uacbd\uc744 Capturing<\/SPAN>\ud558\uc9c0\ub9cc <\/SPAN><\/SPAN><\/FONT><\/P>
\n

RAC<\/SPAN>\ud658\uacbd\uc77c \uacbd\uc6b0\ub098 Capture <\/SPAN>\ud504\ub85c\uc138\uc2a4\uac00 down<\/SPAN>\ub41c \ud6c4 restart<\/SPAN>\ub420 \ub54c Archive log file<\/SPAN>\uc744 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

Access<\/SPAN>\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4. <\/SPAN>\uadf8\ub7ec\ubbc0\ub85c Source<\/SPAN>\uac00 \ub418\ub294 Database<\/SPAN>\ub294 \ubc18\ub4dc\uc2dc Archive log<\/SPAN>\ub85c <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc6b4\uc601\ub418\uc5b4\uc57c \ud55c\ub2e4. <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Logminor Tablespace<\/SPAN><\/B>\uc758 \uc774\ub3d9. <\/SPAN><\/SPAN><\/B><\/FONT><\/P>
\n

Oracle Database<\/SPAN>\uac00 install<\/SPAN>\ub418\uba74 \uae30\ubcf8\uc801\uc73c\ub85c Logminer dictionary Tablespace<\/SPAN>\ub294 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

‘SYSTEM’ tablespace<\/SPAN>\uc5d0 \uc0dd\uc131\ub41c\ub2e4. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uadf8\ub7ec\ub098 \uc2dc\uc2a4\ud15c\uc758 \uc548\uc815\uc131\uc774\ub098 \uc6b4\uc601 \uc131\uc744 \uace0\ub824\ud574\uc11c \ub2e4\ub978 Tablespace<\/SPAN>\ub85c \uc774\ub3d9\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.  <\/SPAN><\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uc774 \uc791\uc5c5\uc740 Source\/Target Database<\/SPAN><\/B> <\/SPAN>\ubaa8\ub450 \uc801\uc6a9\ud55c\ub2e4.. <\/SPAN><\/FONT><\/SPAN><\/P>
\n
\n
\n
\n

\n

1. <\/SPAN>\uc0c8\ub85c\uc6b4 logminer<\/SPAN>\uc6a9 tablespace <\/SPAN>\uc0dd\uc131. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

      <\/SPAN>CREATE TABLESPACE LOGMIR_T DATAFILE   <\/SPAN><\/FONT><\/SPAN><\/P>
\n

        <\/SPAN>EXTENT MANAGEMENT LOCAL  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

         <\/SPAN>SEGMENT SPACE MANAGEMENT AUTO; <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN>    <\/SPAN>‘\/dev\/vgdbtpsts01\/rlvfree02.dbf’ SIZE  <\/SPAN>995M REUSE; <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

2. logminor<\/SPAN>\uc758 tablespace<\/SPAN>\ub97c \uc0c8\ub85c\uc774 \ub9cc\ub4e0 tablespace<\/SPAN>\ub85c \uc774\uad00\ud55c\ub2e4. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

  <\/SPAN>connect \/ as sysdba <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>BEGIN <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>DBMS_LOGMNR_D.SET_TABLESPACE(‘LOGMIR_T’); <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>END; <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>\/ <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

Steams <\/SPAN><\/B>\uad00\ub9ac\uc790 \uacc4\uc815 \uc0dd\uc131 \ubc0f \uad00\ub9ac\uc790 \uacc4\uc815\uc5d0 \uad8c\ud55c \ubd80\uc5ec<\/SPAN><\/SPAN><\/B><\/FONT><\/P>
\n
\n
\n
\n

\n

GRANT CONNECT, RESOURCE, SELECT_CATALOG_ROLE <\/FONT><\/SPAN><\/P>
\n

TO strmadmin IDENTIFIED BY strmadmin; <\/FONT><\/SPAN><\/P>
\n

ALTER USER strmadmin DEFAULT TABLESPACE LOGMIR_T <\/FONT><\/SPAN><\/P>
\n

QUOTA UNLIMITED ON LOGMIR_T; <\/FONT><\/SPAN><\/P>
\n

GRANT EXECUTE ON DBMS_AQADM TO strmadmin; <\/FONT><\/SPAN><\/P>
\n

GRANT EXECUTE ON DBMS_CAPTURE_ADM TO strmadmin; <\/FONT><\/SPAN><\/P>
\n

GRANT EXECUTE ON DBMS_PROPAGATION_ADM TO strmadmin; <\/FONT><\/SPAN><\/P>
\n

GRANT EXECUTE ON DBMS_STREAMS_ADM TO strmadmin; <\/FONT><\/SPAN><\/P>
\n

GRANT EXECUTE ON DBMS_APPLY_ADM TO strmadmin; <\/FONT><\/SPAN><\/P>
\n

GRANT EXECUTE ON DBMS_FLASHBACK TO strmadmin;<\/FONT><\/SPAN><\/P>
\n

grant select any dictionary to strmadmin;   <\/SPAN>— OEM<\/SPAN>\uc758 Stream tool<\/SPAN>\uc744 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uc0ac\uc6a9\ud558\uae30 \uc704\ud574. <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>privilege => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>grantee => ‘strmadmin’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>grant_option => FALSE); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/ <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>privilege => DBMS_RULE_ADM.CREATE_RULE_OBJ, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>grantee => ‘strmadmin’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>grant_option => FALSE); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/FONT><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

<\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.3 <\/SPAN><\/SPAN>Database Link <\/SPAN><\/FONT><\/A>\uc0dd\uc131<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Source<\/SPAN>\uc5d0\uc11c Target<\/SPAN>\uc73c\ub85c \ubcc0\uacbd\uc744 \uc804\ub2ec\ud558\ub294 Propagation<\/SPAN>\uc758 \u2018\uae38\u2019\ub85c \uc0ac\uc6a9\ub418\ub294 Database <\/SPAN><\/SPAN><\/FONT><\/P>
\n

Link<\/SPAN>\ub97c \uc0dd\uc131\ud55c\ub2e4. Global_name=True<\/SPAN>\ub85c \uc9c0\uc815\ud588\uc73c\ubbc0\ub85c database link<\/SPAN>\uc758 \uc774\ub984\uc744 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

Target<\/SPAN>\uc758 Global_name<\/SPAN>\uacfc \uac19\uc740 \uc774\ub984\uc73c\ub85c \uc9c0\uc815\ud574\uc57c \ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n
\n
\n
\n

\n

Source <\/SPAN><\/B>\uc5d0\uc11c \uc791\uc5c5<\/SPAN><\/SPAN><\/B><\/FONT><\/P>
\n

CONNECT strmadmin\/strmadmin@ORCL<\/FONT><\/SPAN><\/P>
\n

CREATE DATABASE LINK TEST<\/B> CONNECT TO strmadmin IDENTIFIED BY <\/FONT><\/SPAN><\/P>
\n

strmadmin USING ‘TEST<\/B>‘;  <\/SPAN>— TNS <\/SPAN>\uc811\uc18d \uc815\ubcf4<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

select * from global_name@TEST<\/B>;  <\/SPAN>–DB Link Name<\/FONT><\/SPAN><\/P>
\n

——————- <\/FONT><\/SPAN><\/P>
\n

TEST<\/FONT><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

<\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.4 <\/SPAN><\/SPAN>Application user <\/SPAN><\/FONT><\/A>\ubc0f table <\/SPAN>\uc0dd\uc131<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Test <\/SPAN>\ub97c \uc704\ud55c \uc0ac\uc6a9\uc790 Schema <\/SPAN>\ubc0f table <\/SPAN>\uc0dd\uc131<\/SPAN><\/SPAN><\/P>
\n
\n
\n
\n

\n

Source and Target <\/SPAN><\/B><\/P>
\n

drop user strmuser cascade; <\/SPAN><\/P>
\n

create user strmuser identified by strmuser <\/SPAN><\/P>
\n

default tablespace logmir_t temporary tablespace temp; <\/SPAN><\/P>
\n

grant connect, resource to strmuser; <\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN><\/P>
\n

connect strmuser\/strmuser <\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN><\/P>
\n

CREATE TABLE DEPT <\/SPAN><\/P>
\n

       <\/SPAN>(DEPTNO NUMBER(2) primary key, <\/SPAN><\/P>
\n

        <\/SPAN>DNAME VARCHAR2(14), <\/SPAN><\/P>
\n

        <\/SPAN>LOC VARCHAR2(13) ); <\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN><\/P>
\n

INSERT INTO DEPT VALUES (10, ‘ACCOUNTING’, ‘NEW YORK’); <\/SPAN><\/P>
\n

INSERT INTO DEPT VALUES (20, ‘RESEARCH’,   <\/SPAN>‘DALLAS’); <\/SPAN><\/P>
\n

INSERT INTO DEPT VALUES (30, ‘SALES’,      <\/SPAN>‘CHICAGO’); <\/SPAN><\/P>
\n

INSERT INTO DEPT VALUES (40, ‘OPERATIONS’, ‘BOSTON’); <\/SPAN><\/P>
\n

commit;<\/SPAN><\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

<\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

 <\/H3>
\n

1.1.5 <\/SPAN><\/SPAN>Object<\/SPAN><\/FONT><\/A>\uc5d0 \ub300\ud55c Grant<\/SPAN>\ubc0f Supplemental Logging <\/SPAN>\uc801\uc6a9<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

\uacb0\uad6d Target<\/SPAN>\uc73c\ub85c \ubcc0\uacbd\uc5d0 \ub300\ud55c LCR<\/SPAN>\uc774 \uc804\ub2ec\ub418\uc5b4 Apply process<\/SPAN>\uc758\ud574 Target Table<\/SPAN>\uc5d0 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

\uc801\uc6a9\ud558\uac8c \ub418\ub294\ub370, <\/SPAN>\uc774 Apply Process<\/SPAN>\ub294 Stream Admin<\/SPAN>\uc758 \uad8c\ud55c\uc73c\ub85c \uc218\ud589\ub418\ubbc0\ub85c Target <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Table<\/SPAN>\uc5d0 \ub300\ud55c \ubcc0\uacbd \uad8c\ud55c\uc744 Stream Admin<\/SPAN>\uc5d0\uac8c \ubd80\uc5ec\ud574\uc57c \ud55c\ub2e4. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\ub610\ud55c \ubcc0\uacbd\ub41c \ub0b4\uc6a9 \uc678\uc5d0 Target Database<\/SPAN>\uc5d0\uc11c row<\/SPAN>\ub97c \uad6c\ubd84\ud558\uae30 \uc704\ud55c column<\/SPAN>\ub4e4\uc5d0 \ub300\ud574 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Supplemental logging<\/SPAN>\uc744 \uc801\uc6a9\ud55c\ub2e4. <\/SPAN>\ubcf4\ud1b5 Source<\/SPAN>\uc758 Primary Key<\/SPAN>\uc640 Destination<\/SPAN>\uc758 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

Unique Key<\/SPAN>\uc5d0 \ub300\ud55c Supplemental Logging<\/SPAN>\uc740 \ud55c\ub2e4. <\/SPAN>\ub9cc\uc57d Apply Process<\/SPAN>\uc758 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

Parallelism<\/SPAN>\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 PK, UK<\/SPAN>\uc678\uc5d0 \ubaa8\ub4e0 Target Database Table<\/SPAN>\uc758 Index<\/SPAN>\ubc0f <\/SPAN><\/SPAN><\/FONT><\/P>
\n

Foreign Key<\/SPAN>\uc5d0\ub3c4 Supplemental Logging<\/SPAN>\uc744 \uc801\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n
\n
\n
\n

\n

Source <\/FONT><\/SPAN><\/B><\/P>
\n

connect strmuser\/strmuser@ORCL<\/FONT><\/SPAN><\/P>
\n

grant all on dept to strmadmin; <\/FONT><\/SPAN><\/P>
\n

ALTER TABLE strmuser.dept ADD SUPPLEMENTAL  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>LOG GROUP log_group_dept_pk (deptno) ALWAYS;  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Target <\/FONT><\/SPAN><\/B><\/P>
\n

grant all on dept to strmadmin;<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

<\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.6 <\/SPAN><\/SPAN>Source\/Target Queue<\/SPAN><\/FONT><\/A>\uc0dd\uc131<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Source <\/FONT><\/SPAN><\/B><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

CONNECT strmadmin\/strmadmin@ORCL<\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

DBMS_STREAMS_ADM.SET_UP_QUEUE( <\/FONT><\/SPAN><\/P>
\n

queue_table => ‘dept_queue_table’, <\/FONT><\/SPAN><\/P>
\n

queue_name  <\/SPAN>=> ‘dept_queue’); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/FONT><\/SPAN><\/P>
\n

Target <\/FONT><\/SPAN><\/B><\/P>
\n

CONNECT strmadmin\/strmadmin@TEST<\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

DBMS_STREAMS_ADM.SET_UP_QUEUE( <\/FONT><\/SPAN><\/P>
\n

queue_table => ‘dept_queue_table’, <\/FONT><\/SPAN><\/P>
\n

queue_name  <\/SPAN>=> ‘dept_queue’); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.7 <\/SPAN><\/SPAN>Propagation <\/SPAN><\/FONT><\/A>\uc0dd\uc131<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Source<\/SPAN>\uc5d0\uc11c \uc804\uc1a1\uc744 \uc704\ud55c Propagation<\/SPAN>\uc744 \uc0dd\uc131\ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

Source <\/FONT><\/SPAN><\/B><\/P>
\n

connect strmadmin\/strmadmin@HIKIM <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES( <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>table_name => ‘strmuser.dept’, <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>streams_name => ‘dept_stream’, <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>source_queue_name => ‘strmadmin.dept_queue’, <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>destination_queue_name => <\/FONT><\/SPAN><\/P>
\n

‘strmadmin.dept_queue@TEST’, <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>include_dml => true, <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>include_ddl => true, <\/FONT><\/SPAN><\/P>
\n

    <\/SPAN>source_database => ‘ORCL\u2019); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.8 <\/SPAN><\/SPAN>Capture <\/SPAN><\/FONT><\/A>\uc0dd\uc131<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Source<\/SPAN>\uc5d0\uc11c \ubcc0\uacbd \ub0b4\uc6a9\uc744 Capturing<\/SPAN>\ud558\ub294 Capture process<\/SPAN>\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

— Source <\/FONT><\/SPAN><\/B><\/P>
\n

connect strmadmin\/strmadmin@ORCL<\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

DBMS_STREAMS_ADM.ADD_TABLE_RULES( <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN> <\/SPAN>table_name   <\/SPAN>=> ‘strmuser.dept’,   <\/SPAN>— <\/SPAN>\ub4f1\ub85d\ud558\ub294 Table<\/SPAN>\uc774\ub984 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

  <\/SPAN>streams_type => ‘capture’, <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>streams_name => ‘dept_capture’,    <\/SPAN>—<\/SPAN>\uc0c8\ub85c\uc6b4 Capture<\/SPAN>\uc774\ub984. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

  <\/SPAN>queue_name   <\/SPAN>=> ‘strmadmin.dept_queue’, — <\/SPAN>\uc1a1\uc2e0 queue <\/SPAN><\/SPAN><\/FONT><\/P>
\n

  <\/SPAN>include_dml  <\/SPAN>=> true, <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>include_ddl  <\/SPAN>=> true); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.9 <\/SPAN><\/SPAN>Table sync<\/SPAN><\/FONT><\/A>\ubc0f Preparation<\/SPAN><\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

\ubcf5\uc81c\ub418\ub294 \ub300\uc0c1\uc5d0 \ub300\ud55c \ucd08\uae30 Sync<\/SPAN>\uc640 Preparation<\/SPAN>\uc744 \uc704\ud574 exp\/imp<\/SPAN>\ub97c \uc0ac\uc6a9\ud55c\ub2e4. <\/SPAN>\ub9cc\uc57d\uc5d0 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Target<\/SPAN>\ucabd\uc5d0 Table<\/SPAN>\uc774 \uc5c6\uac70\ub098 Data<\/SPAN>\uac00 \uc5c6\uc744 \uacbd\uc6b0\uc5d0\ub294 exp option<\/SPAN>\uc911\uc5d0 rows<\/SPAN>\ub97c Yes<\/SPAN>\ub85c \ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

Source <\/FONT><\/SPAN><\/B><\/P>
\n

exp userid=strmuser\/strmuser FILE=dept_instant.dmp TABLES=dept <\/FONT><\/SPAN><\/P>
\n

OBJECT_CONSISTENT=y ROWS=n  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

FTP<\/SPAN>\ub85c dept_instant.dmp file<\/SPAN>\uc744 target<\/SPAN>\uc73c\ub85c \uc804\uc1a1(binary mode). <\/SPAN><\/SPAN><\/FONT><\/P>
\n

  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Target <\/FONT><\/SPAN><\/B><\/P>
\n

imp userid=strmuser\/strmuser FILE=dept_instant.dmp IGNORE=y COMMIT=y<\/FONT><\/SPAN><\/P>
\n

LOG=import.log STREAMS_INSTANTIATION=y <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

rem target<\/SPAN>\uc5d0\ub294 supplemetal logging<\/SPAN>\uc774 \ud544\uc694 \uc5c6\uc73c\ubbc0\ub85c drop<\/SPAN>\ud55c\ub2e4) <\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

CONNECT strmuser\/strmuser@TEST<\/FONT><\/SPAN><\/P>
\n

— import<\/SPAN>\uc5d0 \uc758\ud574 \ucd94\uac00\ub41c logging<\/SPAN>\uc744 \uc0ad\uc81c\ud55c\ub2e4. Target<\/SPAN>\uc740 Logging<\/SPAN>\uc774 \ud544\uc694 \uc5c6\uc74c <\/SPAN><\/SPAN><\/FONT><\/P>
\n

ALTER TABLE strmuser.dept DROP SUPPLEMENTAL LOG GROUP <\/FONT><\/SPAN><\/P>
\n

log_group_dept_pk;<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.10 <\/SPAN><\/SPAN>Apply <\/SPAN><\/FONT><\/A>\uc0dd\uc131<\/SPAN><\/SPAN><\/SPAN><\/FONT><\/H3>
\n
\n
\n
\n

\n

Target Database<\/SPAN>\uc5d0\uc11c Apply Process<\/SPAN>\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

Target  <\/SPAN><\/FONT><\/SPAN><\/B><\/P>
\n

CONNECT strmadmin\/strmadmin@TEST<\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>DBMS_STREAMS_ADM.ADD_TABLE_RULES( <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>table_name => ‘strmuser.dept’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>streams_type => ‘apply’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>streams_name => ‘dept_apply’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>queue_name => ‘strmadmin.dept_queue’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>include_dml => true, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>include_ddl => true, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>source_database => ‘TEST); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/ <\/FONT><\/SPAN><\/P>
\n

REM Apply<\/SPAN>\uc911\uc5d0 Error<\/SPAN>\ub098\ub3c4 \uacc4\uc18d \uc9c4\ud589\ud558\ub294 Parameter <\/SPAN>\uc9c0\uc815 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>DBMS_APPLY_ADM.SET_PARAMETER( <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>apply_name => ‘dept_apply’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>parameter => ‘disable_on_error’, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>value => ‘n’); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.11 <\/SPAN><\/SPAN>SCN Instantiation<\/SPAN><\/FONT><\/A><\/SPAN><\/H3>
\n
\n
\n
\n

\n

SCN Instantiation<\/SPAN>\uc740 Target<\/SPAN>\uc5d0\uc11c \ub4f1\ub85d\ub41c Object<\/SPAN>\uc5d0 \ub300\ud55c Sync<\/SPAN>\uc758 \uae30\uc900 \uc2dc\uc810\uc744 \uc9c0\uc815\ud558\ub294 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

\uac83\uc73c\ub85c Source <\/SPAN>\uc758 SCN<\/SPAN>\uc744 \uc774\uc6a9\ud558\uc5ec \uc9c0\uc815\ud558\uac8c \ub41c\ub2e4. <\/SPAN>\uc989, Source<\/SPAN>\uc5d0\uc11c Target<\/SPAN>\uc73c\ub85c \uc804\ub2ec\ub41c <\/SPAN><\/FONT><\/SPAN><\/P>
\n

LCR<\/SPAN>\uc758 SCN<\/SPAN>\uc774 \uc9c0\uc815\ub41c SCN<\/SPAN>\ubcf4\ub2e4 \ub098\uc911\uc758 \uac83\uc778 \uacbd\uc6b0\ub9cc Apply Process<\/SPAN>\uc5d0 \uc758\ud574 \uc801\uc6a9\ub41c\ub2e4. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/SPAN><\/SPAN>\uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uac83\uc740 SCN<\/SPAN>\uc744 Source<\/SPAN>\uc758 SCN<\/SPAN>\uc744 \uae30\uc900\uc73c\ub85c \uc9c0\uc815\ud558\uc5ec\uc57c \ud55c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

— Source<\/SPAN>\uc758 SCN<\/SPAN>\ub97c \uc774\uc6a9\ud558\uc5ec Target<\/SPAN>\uc5d0\uc11c \uc218\ud589\ud558\ub294 \ubc29\uc2dd. <\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

connect strmadmin\/strmadmin@ORCL  <\/SPAN>— Source<\/B><\/SPAN>\ub85c \uc811\uc18d<\/SPAN><\/B> <\/SPAN><\/FONT><\/P>
\n

  <\/SPAN><\/FONT><\/SPAN><\/P>
\n

DECLARE <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>iscn NUMBER; — Variable to hold instantiation SCN value <\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER(); <\/FONT><\/SPAN><\/P>
\n

      <\/SPAN>— Target<\/SPAN>\uc5d0 \uc801\uc6a9 <\/SPAN><\/SPAN><\/FONT><\/P>
\n

  <\/SPAN>DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN@TEST( <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>source_object_name => ‘strmuser.dept’,      <\/SPAN><\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>source_database_name => \u2018ORCL\u2019, <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>instantiation_scn => iscn); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

1.1.12 <\/SPAN><\/SPAN>Starting Apply\/Capture<\/SPAN><\/FONT><\/FONT><\/A><\/SPAN><\/H3>
\n
\n
\n
\n

\n

\ub9c8\uc9c0\ub9c9\uc73c\ub85c Capture<\/SPAN>\uc640 Apply Process<\/SPAN>\ub97c \uae30\ub3d9\ud558\uc5ec \uc815\uc0c1\uc801\uc73c\ub85c Setup<\/SPAN>\uc774 \ub418\uc5c8\ub294\uc9c0 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

Test<\/SPAN>\ub97c \ud55c\ub2e4. Propagation<\/SPAN>\uc740 \uc0dd\uc131\ud560 \ub54c \uc790\ub3d9\uc73c\ub85c Enable<\/SPAN>\ub41c\ub2e4.<\/SPAN><\/SPAN><\/FONT><\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

–Target(Apply start) <\/FONT><\/SPAN><\/B><\/P>
\n

CONNECT strmadmin\/strmadmin@TEST<\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>DBMS_APPLY_ADM.START_APPLY( <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>apply_name => ‘dept_apply’); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/ <\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

–Source(Capture Start) <\/FONT><\/SPAN><\/B><\/P>
\n

CONNECT strmadmin\/strmadmin@ORCL<\/FONT><\/SPAN><\/P>
\n

 <\/SPAN><\/FONT><\/SPAN><\/P>
\n

BEGIN <\/FONT><\/SPAN><\/P>
\n

  <\/SPAN>DBMS_CAPTURE_ADM.START_CAPTURE( <\/FONT><\/SPAN><\/P>
\n

   <\/SPAN>capture_name => ‘dept_capture’); <\/FONT><\/SPAN><\/P>
\n

END; <\/FONT><\/SPAN><\/P>
\n

\/<\/SPAN><\/SPAN><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

1.ORACLE STREAMS CONFIGURE  1.1 \uc0ac\uc804 \uc124\uc815 1.1.1 Parameter \uc124\uc815 (9i \uae30\uc900) \uc0ac\uc804 \uc791\uc5c5\uc73c\ub85c \uc544\ub798\uc758 \ud30c\ub77c\ubbf8\ud130\uac12 \ub4e4\uc744 \uc124\uc815\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4. (9i \uae30\uc900, 11g \uc758 \uacbd\uc6b0 \ubcc0\uacbd\ub418\uac70\ub098 \uae30\ubcf8\uac12\uc73c\ub85c \uc9c0\uc815\ub418\uc5b4 \ud2b9\ubcc4\ud788 \uc9c0\uc815\ud574 \uc8fc\uc9c0 \uc54a\uc544\ub3c4 \uac00\ub2a5)     AQ_TM_PROCESSES=2 1\uc774\ub098 1\uc774\uc0c1\uc758 \uac12\uc744 \uc9c0\uc815\ud55c\ub2e4. \uc774\ub294 capture\uc5d0 \uc758\ud574 capturing\ub41c lcr\uc758 propagation\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 queue\uc758 agent \uc218\ub97c \ub098\ud0c0\ub0b8\ub2e4.    ARCHIVE_LAG_TARGET=1800       RAC\ud658\uacbd\uc5d0\uc11c, Capture […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[541],"tags":[539,540],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1001"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1001"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1001\/revisions"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}