怎么做查成绩网站,搜索推广和信息流推广的区别,上海浦东医院网站建设,网站分享的功能怎么做前言: Ogg集成模式降级为经典模式的场景比较少#xff0c;因为降级为经典模式会导致无法支持压缩表同步#xff0c;XA事务#xff0c;多线程模式#xff0c;PDB模式同步等功能#xff0c;除非遇到集成模式暂时无法解决的bug或者环境不支持集成模式#xff0c;比如DG备库环…前言: Ogg集成模式降级为经典模式的场景比较少因为降级为经典模式会导致无法支持压缩表同步XA事务多线程模式PDB模式同步等功能除非遇到集成模式暂时无法解决的bug或者环境不支持集成模式比如DG备库环境 配置介绍:
OGG软件:19.1.0.0.4 源端 extract :ext_text pump :pum_test 目标端: replicat:rep_test
replicat进程降级: 1 关闭replicat进程
GGSCI stop replicat rep_test 2 删除集成复制的参数
GGSCI edit params rep_test
--删除
DBOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 100, PARALLELISM 2) 3 添加检查表
GGSCI DBLOGIN userid ogg, password go_20230_W506
GGSCI delete CHECKPOINTTABLE ogg.REP_CHKPT
GGSCI ADD CHECKPOINTTABLE ogg.REP_CHKPT 4 修改为经典复制模式
GGSCI ALTER REPLICAT rep_test, NONINTEGRATED, CHECKPOINTTABLE ogg.REP_CHKPT 5 启动应用进程
GGSCI start rep_test 6 确认使用了经典模式
查看replicat进程信息已经没有没有INTEGRATED Replicat
GGSCI info rep_test,detail
REPLICAT REP_TEST Last Started 2023-11-03 16:15 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Process ID 20588
Log Read Checkpoint File /u01/ogg/dirdat/ro0000000032023-11-03 16:24:31.583771 RBA 314432158
查询应用进程的数据字典也返回为空
GGSCI select * from DBA_APPLY;
GGSCI select * from DBA_GG_INBOUND_PROGRESS;
extract进程降级: 1 关闭extract进程
GGSCI STOP EXT_TEST 2 确认当前进程是否可以进行downgrade,需要确保在downgrade之前的事务已经写入队列文件
GGSCI DBLOGIN userid ogg, password go_20230_W506
GGSCI INFO EXT_TEST DOWNGRADE
表示可以进行降级
Extract EXT_TEST is ready to be downgraded from integrated capture. Archive logs corresponding to SCN 8145010 and higher must be accessible by the downgraded extract. 3 降级extract进程
注意如果是RAC 要写对应的threads数量
GGSCI alter EXT_TEST downgrade tranlog threads 2
Extract EXT_TEST successfully downgraded from integrated capture 4 extract取消注册到数据库
GGSCI UNREGISTER extract EXT_TEST DATABASE
2023-11-03 16:24:22 INFO OGG-01750 Successfully unregistered EXTRACT EXT_TEST from database. 5 删除集成模式的参数添加经典模式参数tranlogoptions
删除集成模式的参数
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 100, PARALLELISM 2) 6 开启extract进程
GGSCI START EXT_TEST 7 确认使用了经典模式
GGSCI info EXT_TEST
EXTRACT EXT_TEST Last Started 2023-11-03 16:25 Status RUNNING
Checkpoint Lag 00:00:23 (updated 00:00:04 ago)
Process ID 17271
Log Read Checkpoint Oracle Redo Logs2023-11-03 16:21:37 Thread 1, Seqno 256, RBA 2394476SCN 0.8145013 (8145013)
Log Read Checkpoint Oracle Redo Logs2023-11-03 16:25:14 Thread 2, Seqno 163, RBA 272912SCN 0.8701078 (8701078)
