重庆思庄Oracle、Redhat认证学习论坛

标题: ogg在启动应用进程时报错OGG-00412 [打印本页]

作者: denglj 时间: 2022-12-26 18:01
标题: ogg在启动应用进程时报错OGG-00412

问题描述：ogg在启动应用进程时报错OGG-00412，如下所示：

源端：IP 192.168.133.108 数据库oracle 10.2.0.4 64位，实例名：orcl 主机名：leo-10g-ogg + oel5.11 64位

目标端：IP 192.168.133.109 数据库oracle 19.16.0.0 64位，实例名：simdb 主机名：leo-19c-ogg + centos 7.9 64位

ogg 软件：

源端：fbo_ggs_Linux_x64_ora10g_64bit.tar

目标端：191004_fbo_ggs_Linux_x64_shiphome.zip

异常重现：

GGSCI(leo-10g-ogg) 26> start rep1

SendingSTART request to MANAGER ...

REPLICATREP1 starting

GGSCI(leo-10g-ogg) 27> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DP1 00:00:00 00:00:07

EXTRACT RUNNING EXTA 00:00:00 00:00:03

REPLICAT STOPPED REP1 00:00:00 00:03:15

告警日志：

DISCARDFILE./dirrpt/rep.dsc format release 12.2, APPEND, MEGABYTES 1024

SourceContext :

SourceModule : [er.main]

SourceID :[/scratch/sganti/view_storage/sganti_core_lin64/oggcore/OpenSys/src/app/er/rep.c]

SourceFunction : [create_discard_file]

SourceLine : [9352]

ThreadBacktrace : [7] elements

:[/u01/app/ogg/replicat(CMessageContext::AddThreadContext()+0x26) [0x5ec2e6]]

:[/u01/app/ogg/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsignedint, ...)+0x7b2) [0x5e2db2]]

:[/u01/app/ogg/replicat(_MSG_ERR_STARTUP_BADARG_DISCARDFILE_INVALID_OPENMODE(CSourceContext*,CMessageFactory::MessageDisposition)+0x87) [0x58c4a7]]

:[/u01/app/ogg/replicat [0x5021fe]]

:[/u01/app/ogg/replicat(main+0x194) [0x506374]]

:[/lib64/libc.so.6(__libc_start_main+0xf4) [0x3c4701d9f4]]

:[/u01/app/ogg/replicat(__gxx_personality_v0+0x1da) [0x4e31ba]]

2022-12-1416:30:11 ERROR OGG-00412 Must be PURGE, APPEND, MAXBYTES, or MEGABYTES.

2022-12-1416:30:11 ERROR OGG-01668 PROCESS ABENDING.

解决方案：

此处直接将应用进程中的discardfile参数屏蔽.

GGSCI(leo-10g-ogg) 31> view param rep1

REPLICATrep1

setenv(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

--setenv(ORACLE_SID=)

useridogg@ORCL,password ogg

REPORT AT08:59

REPORTCOUNTEVERY 30 MINUTES, RATE

CACHEMGRCACHESIZE 2048MB,CACHEDIRECTORY ./dirtmp

REPERRORDEFAULT, ABEND

--DISCARDFILE./dirrpt/rep1.dsc format release 12.2, APPEND, MEGABYTES 1024

DISCARDROLLOVERAT 3:00

GETTRUNCATES

ALLOWNOOPUPDATES

APPLYNOOPUPDATES

ASSUMETARGETDEFS

DBOPTIONSDEFERREFCONST

--DBOPTIONSSUPPRESSTRIGGERS

DDLINCLUDE MAPPED

DDLOPTIONSREPORT

DDLERRORDEFAULT IGNORE RETRYOP

MAPSCOTT.*, TARGET SCOTT.*;

--开启应用进程

GGSCI(leo-10g-ogg) 29> start rep1

SendingSTART request to MANAGER ...

REPLICATREP1 starting

GGSCI(leo-10g-ogg) 30> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DP1 00:00:00 00:00:02

EXTRACT RUNNING EXTA 00:00:00 00:00:05

REPLICAT RUNNING REP1 00:00:00 00:00:01

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)