First, you need to provision DBaaS and GGCS instances on both the source and the target.After the provisioning, you should have:
- Source: a PDB in an Oracle Database 12c with GGCS
- Target: Oracle Database 11.2.0.4 with GGCS
sudo ssh -f -N -i ~/.ssh/jinyu_opc -v -D 127.0.0.1:9000 [email protected]
extgdrds.prm:
extract extgdrds useridalias ggadmin EXTTRAIL ./dirdat/od ddl include all ddloptions addtrandata,getreplicates, report TABLE pdb1.pmdemo.*;
pmpgdrds.prm
extract pmpgdrds RMTHOST 129.152.156.178, MGRPORT 7744,socksproxy 127.0.0.1:9000 discardfile ./dirrpt/pumgdop.dsc, purge RMTTRAIL ./dirdat/od PASSTHRU TABLE pdb1.pmdemo.member;
GGSCI> obey dirprm/del_gdrds.oby stop * pause 5 info all sh ls ./dirdat sh rm ./dirdat/od* sh ls ./dirdat dblogin useridalias ggadmin unregister extract extgdrds database pause 5 delete extgdrds! delete pmpgdrds! info all GGSCI> obey dirprm/add_extgdrds.oby dblogin useridalias ggadmin add extract extgdrds integrated tranlog, begin now add exttrail ./dirdat/od extract extgdrds register extract extgdrds database container(PDB1) pause 5 start extgdrds pause 25 info extgdrds info all GGSCI> obey dirprm/add_pmpgdrds.oby ADD EXTRACT pmpgdrds EXTTRAILSOURCE ./dirdat/od BEGIN NOW ADD RMTTRAIL ./dirdat/od EXTRACT pmpgdrds start pmpgdrds pause 10 info pmpgdrds info all
To add the replicat on the target side, you can set the replicat as follows:
repgdopc.prm
replicat repgdopc useridalias ggadmin dboptions integratedparams(parallelism 2) discardfile ./dirrpt/repgdrds.dsc,append megabytes 50 ddl include all map pdb1.pmdemo.*, TARGET pmdemo.*;
GGSCI> obey dirprm/add_repgdopc.oby add replicat repgdopc, integrated, exttrail ./dirdat/od pause 10 info all
Answer:This is normally because you use the wrong version of Oracle GoldenGate for the database. For example, you use Oracle GoldenGate for 12c Database to configure for Oracle Database 11g.
Answer: You need to grant the user(i.e. pmdemo user) the quota on USERS tablespace with the alter user pmdemo quota 10M on users; command.