暂无图片
oracle11grac删除节点,部署的ogg进程报错
我来答
分享
NIU
2021-08-13
oracle11grac删除节点,部署的ogg进程报错

描述:原来是三个节点,后来为了测试ogg源端进程的threads参数,结果删除一个节点后,重新配置ogg抽取进程,操作delete ext1,
然后重新添加:
add extract EXT1,tranlog,begin now,THREADS 2
add exttrail ./dirdat/xt, extract ext1

启动ogg进程报错:
ERROR OGG-01937 Extract is not configured to capture changes from thread 3. To avoid data loss, the Extract must be dropped and recreated with the THREADS option to specify the correc
t number of RAC instances. See the Oracle GoldenGate administration documentation for the procedure to follow.

现在数据库里就是两个节点的实例,启动源端的extract进程就报错,帮忙给看看

我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
你好我是李白

增加删除节点,需要重建extract,可以参考文档
https://www.modb.pro/doc/42812

暂无图片 评论
暂无图片 有用 0
打赏 0
NIU

还是不行,按照你说的那个步骤操作了,还是报相同的问题。
++++++
2021-02-08 02:11:23 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2021-02-08 02:11:23 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, ext1.prm: Default thread stack size: 10485760.
2021-02-08 02:11:23 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to (Thread 1) Sequence 220, RBA 23568, SCN 0.0 (0).
2021-02-08 02:11:23 INFO OGG-01560 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to (Thread 1) Sequence 220, RBA 23568, SCN 0.0 (0).
2021-02-08 02:11:23 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to (Thread 2) Sequence 149, RBA 30276624, SCN 0.4224995 (4224995).
2021-02-08 02:11:23 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to (Thread 2) Sequence 149, RBA 30276624, SCN 0.4224995 (4224995), 2021 M02 8 01:39:24.
2021-02-08 02:11:23 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2021-02-08 02:11:23 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed for Thread 1, Sequence 220, RBA 23568, SCN 0.3674411 (3674411), 2021 M02 17 09:25:43.
2021-02-08 02:11:23 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery initialization completed for target file ./dirdat/ex000000216, at RBA 1726, CSN 3862474.
2021-02-08 02:11:23 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file ./dirdat/ex is using format RELEASE 12.2.
2021-02-08 02:11:23 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext1.prm: Rolling over remote file ./dirdat/ex000000216.
2021-02-08 02:11:23 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed for Thread 2, Sequence 149, RBA 30276624, SCN 0.4224993 (4224993), 2021 M02 8 01:39:24.
2021-02-08 02:11:24 INFO OGG-02232 Oracle GoldenGate Capture for Oracle, pump1.prm: Switching to next trail file ./dirdat/ex000000217 at 2021-02-08 02:11:24.234699 due to EOF. with current RBA 1,726.
2021-02-08 02:11:26 ERROR OGG-01937 Oracle GoldenGate Capture for Oracle, ext1.prm: Extract is not configured to capture changes from thread 3. To avoid data loss, the Extract must be dropped and recreated with the THREADS option to specify the correct number of RAC instances. See the Oracle GoldenGate administration documentation for the procedure to follow.

++++++++

暂无图片 评论
暂无图片 有用 0
打赏 0
杨卓

OGG抽取进程需要删除后,在新建,你这个操作了没。 另外就是检查DB的线程是否只剩下了2个,不要说DB实例没删除干净。 最后就是上面2个情况都不是,使用参数屏蔽线程3参考那个MOS
详细一点的可以看我之前发的测试
https://www.modb.pro/doc/35751

暂无图片 评论
暂无图片 有用 0
打赏 0
NIU

我的删除节点操作:
6.1.删除实例

此处我在节点db3执行的而且我删除的就是节点他不让操作,需要换一个节点重新执行。

此图是我在节点1执行的。

至此db3上的数据库实例已删除。
6.2. 删除db_home
[oracle@db1 ~]$ cd $ORACLE_HOME

[oracle@db1 bin]$
./runInstaller -updateNodeList ORACLE_HOME=/home/u01/app/oracle/product/11.2.0/db_1 “CLUSTER_NODES={db1, db2}” -local

6.3. 删除GRID
6.3.1.停止并删除第三个节点VIP服务(root)
停止并删除第三个节点VIP服务(root)
Root用户下操作
[root@db1 crs]# ls -l /home/g01/app/11.2.0/grid/bin/srvctl

[root@db1 crs]# /home/g01/app/11.2.0/grid/bin/srvctl stop vip -i db3 -f
[root@db1 crs]# /home/g01/app/11.2.0/grid/bin/srvctl remove vip -i db3 -f

6.3.2.删除在crs中的第三个节点的信息(root)
先停止要删除的节点
[root@db3 ~]# /home/g01/app/11.2.0/grid/bin/crsctl stop cluster
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘db3’
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘db3’
CRS-2673: Attempting to stop ‘ora.CRS.dg’ on ‘db3’
CRS-2673: Attempting to stop ‘ora.DATADG.dg’ on ‘db3’
CRS-2677: Stop of ‘ora.DATADG.dg’ on ‘db3’ succeeded
CRS-2677: Stop of ‘ora.CRS.dg’ on ‘db3’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘db3’
CRS-2677: Stop of ‘ora.asm’ on ‘db3’ succeeded
CRS-2673: Attempting to stop ‘ora.ons’ on ‘db3’
CRS-2677: Stop of ‘ora.ons’ on ‘db3’ succeeded
CRS-2673: Attempting to stop ‘ora.net1.network’ on ‘db3’
CRS-2677: Stop of ‘ora.net1.network’ on ‘db3’ succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘db3’ has completed
CRS-2677: Stop of ‘ora.crsd’ on ‘db3’ succeeded
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘db3’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘db3’
CRS-2673: Attempting to stop ‘ora.asm’ on ‘db3’
CRS-2677: Stop of ‘ora.evmd’ on ‘db3’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘db3’ succeeded
CRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘db3’
CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘db3’ succeeded
CRS-2677: Stop of ‘ora.ctssd’ on ‘db3’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘db3’
CRS-2677: Stop of ‘ora.cssd’ on ‘db3’ succeeded

6.3.3.删除crs中的节点三信息(root)
[root@db1 bin]# /home/g01/app/11.2.0/grid/bin/crsctl delete node -n db3
CRS-4661: Node db3 successfully deleted.

6.3.4.删除在CRS中的第三个节点信息(grid)
/home/g01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/home/g01/app/11.2.0/grid “CLUSTER_NODES={db1,db2}” CRS=TRUE -silent

6.3.5.检查是否被删除(grid)
[grid@db1 bin]$ cluvfy stage -post nodedel -n db3

至此删除节点操作已完成。

+++++++++
以上是我删除节点的操作。
之后我的ogg部署在节点2上,ogg版本是12.2.0.2.2
没删除节点之前的节点节点数为3,想着ogg进程应该没问题,但是观察一段时间后,报错了,后来把抽取进程重新添加,操作如下:
dblogin userid ogg12,password 123456
stop ext1
delete ext1

add extract EXT1,tranlog,begin now,THREADS 2
add exttrail ./dirdat/xt, extract ext1

还有说要更新current checkpoint,recovery checkpoint,还有更改extrail或者rmttrail的write checkpoint,

info ext1
image.png

–current checkpoint
alter EXTRACT ext1, TRANLOG, EXTSEQNO 220, EXTRBA 23568,thread 1
alter EXTRACT ext1, TRANLOG, EXTSEQNO 146, EXTRBA 9005964,thread 2

–recovery checkpoint
ALTER EXTRACT ext1, IOEXTSEQNO 220, IOEXTRBA 23568,thread 1
ALTER EXTRACT ext1, IOEXTSEQNO 146, IOEXTRBA 9005964,thread 2

以上就是处理步骤,帮忙看看哪里有问题。

暂无图片 评论
暂无图片 有用 0
打赏 0
NIU

按照杨老师的操作了还是不行。
我觉得还是数据库删除节点没有删除干净,但是操作了也还是不行,具体操作如下:
删除节点验证:[grid@db1 bin]$ cluvfy stage -post nodedel -n db3
Performing post-checks for node removal
Checking CRS integrity…
Clusterware version consistency passed
CRS integrity check passed
Node removal check passed
Post-check for node removal was successful.
上面的查询说明删除成功了。
下面就是配置ogg进程操作。我的ogg是在节点2部署的源端和目标端都是ogg12版本,两端都是经典模式。
源端信息:
image.png

info ext1 showch信息如下:
++++++++++++++++++++++++++++++++++
GGSCI (db2 as ogg12@ora2) 22> info ext1 showch

EXTRACT EXT1 Last Started 2021-02-09 02:16 Status ABENDED
Checkpoint Lag unknown (updated 00:19:39 ago)
Log Read Checkpoint Oracle Redo Logs
2021-02-17 09:25:43 Thread 1, Seqno 220, RBA 36880
SCN 0.3674428 (3674428)
Log Read Checkpoint Oracle Redo Logs
2021-02-09 02:12:55 Thread 2, Seqno 150, RBA 38165900
SCN 0.4339701 (4339701)

Current Checkpoint Detail:

Read Checkpoint #1

Oracle Threaded Redo Log

Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 220
RBA: 23568
Timestamp: 2021-02-17 09:25:43.000000
SCN: 0.3674411 (3674411)
Redo File: +DATADG/arch_ora/1_220_1064932247.dbf

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 220
RBA: 23568
Timestamp: 2021-02-17 09:25:43.000000
SCN: 0.3674411 (3674411)
Redo File: +DATADG/arch_ora/1_220_1064932247.dbf

Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 220
RBA: 36880
Timestamp: 2021-02-17 09:25:43.000000
SCN: 0.3674428 (3674428)
Redo File: +DATADG/arch_ora/1_220_1064932247.dbf

Read Checkpoint #2

Oracle Threaded Redo Log

Startup Checkpoint (starting position in the data source):
Thread #: 2
Sequence #: 150
RBA: 38156304
Timestamp: 2021-02-09 02:12:54.000000
SCN: 0.4339675 (4339675)
Redo File: +DATADG/ora/onlinelog/group_4.397.1064932335

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 2
Sequence #: 150
RBA: 38156304
Timestamp: 2021-02-09 02:12:54.000000
SCN: 0.4339675 (4339675)
Redo File: +DATADG/ora/onlinelog/group_4.397.1064932335

Current Checkpoint (position of last record read in the data source):
Thread #: 2
Sequence #: 150
RBA: 38165900
Timestamp: 2021-02-09 02:12:55.000000
SCN: 0.4339701 (4339701)
Redo File: +DATADG/ora/onlinelog/group_4.397.1064932335

Write Checkpoint #1

GGS Log Trail

Current Checkpoint (current write position):
Sequence #: 2
RBA: 23568
Timestamp: 2021-02-09 01:55:53.156440
Extract Trail: ./dirdat/ex
Seqno Length: 6
Flip Seqno Length: Yes
Trail Type: EXTTRAIL

Header:
Version = 2
Record Source = A
Type = 11

Input Checkpoints = 2

Output Checkpoints = 1

File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 4096
Current Offset = 0

Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0

Status:
Start Time = 2021-02-09 02:16:55
Last Update Time = 2021-02-09 02:16:55
Stop Status = A
Last Result = 0
GGSCI (db2 as ogg12@ora2) 23>

++++++++++++++++++++++++++++++++++

操作:
dblogin userid ogg12,password 123456
delete EXTRACT ext1
ADD EXTRACT ext1, TRANLOG,THREADS 2,BEGIN NOW
add exttrail ./dirdat/ex,extract ext1, megabytes 50, SEQNO 2, RBA 23568
ALTER EXTRACT ext1,TRANLOG,EXTSEQNO 220, EXTRBA 23568,thread 1
ALTER EXTRACT ext1, IOEXTSEQNO 220, IOEXTRBA 1040,thread 1
ALTER EXTRACT ext1,TRANLOG,EXTSEQNO 150, EXTRBA 26987024,thread 2
ALTER EXTRACT ext1, IOEXTSEQNO 155, IOEXTRBA 26987024,thread 2

然后重新尝试重启源端抽取进程ext1,还是报错:“
2021-02-09 02:16:54 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg12/BR/EXT1.
2021-02-09 02:16:54 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 140191709984512.
2021-02-09 02:16:54 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg12/dirtmp.
2021-02-09 02:16:55 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2021-02-09 02:16:55 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, ext1.prm: Default thread stack size: 10485760.
2021-02-09 02:16:55 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to (Thread 1) Sequence 220, RBA 23568, SCN 0.3674411 (3674411).
2021-02-09 02:16:55 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to (Thread 1) Sequence 220, RBA 23568, SCN 0.3674411 (3674411), 2021 M02 17 09:25:43.
2021-02-09 02:16:55 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to (Thread 2) Sequence 150, RBA 38156304, SCN 0.4339675 (4339675).
2021-02-09 02:16:55 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to (Thread 2) Sequence 150, RBA 38156304, SCN 0.4339675 (4339675), 2021 M02 9 02:12:54
.
2021-02-09 02:16:55 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2021-02-09 02:16:55 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery initialization completed for target file ./dirdat/ex000000289, at RBA 1726, CSN 3862474.
2021-02-09 02:16:55 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file ./dirdat/ex is using format RELEASE 12.2.
2021-02-09 02:16:55 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed for Thread 1, Sequence 220, RBA 23568, SCN 0.3674411 (3674411)
, 2021 M02 17 09:25:43.
2021-02-09 02:16:55 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ext1.prm: Rolling over remote file ./dirdat/ex000000289.
2021-02-09 02:16:55 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext1.prm: Position of first record processed for Thread 2, Sequence 150, RBA 38156304, SCN 0.4339675 (43396
75), 2021 M02 9 02:12:54.
2021-02-09 02:16:57 ERROR OGG-01937 Oracle GoldenGate Capture for Oracle, ext1.prm: Extract is not configured to capture changes from thread 3. To avoid data loss, the Extract must
be dropped and recreated with the THREADS option to specify the correct number of RAC instances. See the Oracle GoldenGate administration documentation for the procedure to follow.
2021-02-09 02:36:05 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2021-02-09 02:36:34 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info ext1 showch.

还是有“2021-02-09 02:16:57 ERROR OGG-01937 Oracle GoldenGate Capture for Oracle, ext1.prm: Extract is not configured to capture changes from thread 3. To avoid data loss, the Extract must
be dropped and recreated with the THREADS option to specify the correct number of RAC instances. See the Oracle GoldenGate administration documentation for the procedure to follow.”

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
oracle 数据库的表覆盖以后要重新导入?
回答 1
没看懂。表如果是被全表更新了,你可以用闪回先查查原来的。用闪回来恢复。
oracle 9i直接升级11g,12c
回答 4
建议先从9i升级到11g过渡。19C是12C的稳定版本,建议使用19C
ogg初始化后,目标端的复制进程未使用源端提供的scn号启动,导致后续更新的数据目标端不同步,进程都是running的,这个得咋弄
回答 1
可以参考下面办法:重新初始化。目标端利用闪回数据库或者可以的话表空间定点恢复也行,如果trail文件还在,重新指定scn应用。配置oggveridata进行比对,空闲时repair。注:第二个办法需要
连接不上实例,lsnrctl status提示The listener supports no services 问题解决方法
回答 4
已采纳
修改监听文件/deploy/oracle/product/11.2.0.4/network/admin/listener.ora监听文件,通过lsnrctlstatus能查看到添加一下内容,重启即可、
Oracle 搭建adg要重启主库吗?
回答 5
如果没开归档就需要。
一体机/u01目录下增长异常
回答 6
已采纳
看下数据库的告警日志,应该是遇到bug了,bug一旦触发就会生成cdmp,需要修复(有可能改参数、有可能需要打补丁)。如果短期内无法修复,需要写脚本用crontab定时清理。
关于使用数据库升级助手 (DBUA)
回答 1
已采纳
C.它会自动对Oracle环境变量进行必要的更改。
oracle的users表空间移植到另外一个文件路径 ,必须关库下移动。并且移好后起到mount然后在数据库里进行rename数据库文件操作,v$datafile查询正常后再起到open吗?
回答 1
已采纳
在12c之前是这样的,12c之后可以无需停库进行移动。Renamedatabaseandthenmovedatafileonlinein12.2(DocID2258871.1)
schema 恢复
回答 4
只能按单表空间粒度恢复,建议利用备份在其他机器恢复,不要在源库进行。
Oracle如何导出.db的文件?
回答 2
已采纳
rmancopydatafile备份数据文件