On source
stop extint
stop pint
cd /u01/app/oracle/product/ogg_src/dirdat
rm -rf *
delete extint
delete pint
DELETE EXTTRAIL /u01/app/oracle/product/ogg_src/dirdat/lt
DELETE RMTTRAIL /u01/app/oracle/product/ogg_src/dirdat/rt
sqlplus ggtraining1/Welcome1@pdb1
delete from dept11;
delete from emp11;
commit;
dblogin useridalias gg_cdb
unregister extract extint database
ADD EXTRACT extint, INTEGRATED TRANLOG, BEGIN NOW
REGISTER EXTRACT extint DATABASE CONTAINER (pdb1)
ADD EXTTRAIL /u01/app/oracle/product/ogg_src/dirdat/lt, EXTRACT extint
ADD EXTRACT pint, EXTTRAILSOURCE /u01/app/oracle/product/ogg_src/dirdat/lt
ADD RMTTRAIL /u01/app/oracle/product/ogg_trg/dirdat/rt, EXTRACT pint
start extint
start pint
On target
stop repint
cd /u01/app/oracle/product/ogg_trg/dirdat
rm -rf *
delete repint
sqlplus ggtraining2/Welcome1@pdb2
delete from dept22;
delete from emp22;
commit;
dblogin userid c##ggadmin2@pdb2,password Welcome1
ADD REPLICAT repint,integrated EXTTRAIL /u01/app/oracle/product/ogg_trg/dirdat/rt
start repint
Testing
On Source
sqlplus ggtraining1/Welcome1@pdb1
insert into DEPT11 (DEPTNO, DNAME, LOC)
values(10, ‘ACCOUNTING’, ‘NEW YORK’);
insert into DEPT11
values(20, ‘RESEARCH’, ‘DALLAS’);
insert into DEPT11
values(30, ‘SALES’, ‘CHICAGO’);
insert into DEPT11
values(40, ‘OPERATIONS’, ‘BOSTON’);
commit;
On Target
sqlplus ggtraining2/Welcome1@pdb2
select * from dept22
