extract EXT01
useridalias SRC1CDB domain OracleGoldenGate
exttrail ET
sourcecatalog SRC1PDB
table APPADMIN.*;

事前作業：
・ソースDB（DBaaS）のDBを停止
・個別パッチの配置（私は/tmp配下で作業）
・個別パッチの解凍（unzip p29374604_189000DBRU_Linux-x86-64.zip）
・oracleユーザーへスイッチ
以下実行ログ：
[oracle@ソースDBのホスト名 tmp]$ export ORACLE_HOME=/u01/app/oracle/product/18.0.0/dbhome_1 
[oracle@ソースDBのホスト名 tmp]$ cd 29374604/      ←個別パッチのディレクトリに移動
[oracle@ソースDBのホスト名29374604]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.18
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/18.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/18.0.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.18
OUI version       : 12.2.0.4.0
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29374604  
Do you want to proceed? [y|n]
y　　　　　　　←「y」を入力
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/18.0.0/dbhome_1')
Is the local system ready for patching? [y|n]
y　　　　　　　←「y」を入力
User Responded with: Y
Backing up files...
Applying interim patch '29374604' to OH '/u01/app/oracle/product/18.0.0/dbhome_1'
Patching component oracle.rdbms, 18.0.0.0.0...
Patch 29374604 successfully applied.
OPatch succeeded.     　　　　　　　　　　 ←OPatchの適用が成功しました。
[oracle@ソースDBのホスト名29374604]$ exit

事後作業：DBaaSシステムの再起動

replicat REP01
useridalias target1adw_low domain OracleGoldenGate
dboptions enable_instantiation_filtering
sourcecatalog SRC1PDB
MAP APPADMIN.*, TARGET APPADMIN.*;

[opc@プロキシサーバのhostname 鍵ファイル置き場]$ ssh -i myrsa opc@Oracle GoldenGate Microservices Edition  for Oracle 19.1.0.0.4サーバのPrivateIPアドレス
-bash-4.2$　export ORACLE_HOME=/u01/app/client/oracle18
-bash-4.2$　export TNS_ADMIN=/u02/deployments/Source/etc
-bash-4.2$　cd $ORACLE_HOME/bin
-bash-4.2$　./sqlplus appadmin/*************@SRC1PDB   ←ソースDB（DBaaS）へ接続
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 31 08:47:47 2020　Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production　Version 18.9.0.0.0

SQL> select emp_id, emp_name from emp;
no rows selected
SQL> insert into emp values(111,'otsuka111');
1 row created.
SQL> commit;
Commit complete.
SQL> select emp_id, emp_name from emp;
EMP EMP_NAME
--- ----------
111 otsuka111
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.9.0.0.0

-bash-4.2$ export TNS_ADMIN=/u02/deployments/Target/etc
-bash-4.2$ ./sqlplus appadmin/**************@target1adw_low    ←ターゲットDBへ接続
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 31 08:55:43 2020　Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production　Version 18.4.0.0.0

SQL> select emp_id, emp_name from emp;
EMP EMP_NAME
--- ----------
111 otsuka111　　　　←データが反映されていることが確認できました。
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

※実験を続けます（DELETEは反映されるのか？さらにINSERTしたら場合のターゲットDBのemp tabelの状態は？）
-bash-4.2$　export TNS_ADMIN=/u02/deployments/Source/etc
-bash-4.2$　./sqlplus appadmin/*************@SRC1PDB   ←ソースDB（DBaaS）へ接続
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 31 08:47:47 2020　Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production　Version 18.9.0.0.0

SQL> select emp_id, emp_name from emp;
EMP EMP_NAME
--- ----------
111 otsuka111
SQL> delete from emp where emp_id=111;
1 row deleted.
SQL> commit;
Commit complete.
SQL> insert into emp values(511,'otsuka511');
1 row created.
SQL> commit;
Commit complete.
SQL> insert into emp values(512,'otsuka512');
1 row created.
SQL> commit;
Commit complete.
SQL> insert into emp values(513,'otsuka513');
1 row created.
SQL> commit;
Commit complete.
SQL> insert into emp values(514,'otsuka514');
1 row created.
SQL> commit;
Commit complete.

SQL> insert into emp values(515,'otsuka515');
1 row created.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.9.0.0.0

-bash-4.2$ export TNS_ADMIN=/u02/deployments/Target/etc
-bash-4.2$ ./sqlplus appadmin/**************@target1adw_low    ←ターゲットDBへ接続
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 31 08:55:43 2020　Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 – Production　Version 18.4.0.0.0

SQL> select emp_id, emp_name from emp order by 1;
EMP EMP_NAME
--- ----------
511 otsuka511
512 otsuka512
513 otsuka513
514 otsuka514
515 otsuka515　　　　　　　　　←DELETE、INSERT共に反映されていることが確認できました。

SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
-bash-4.2$ exit