后使用快捷导航没有帐号？
查看: 2313|回复: 3
OGG-01496怎么解决，网上也没有查到
金牌会员, 积分 1550, 距离下一级还需 1450 积分
论坛徽章:6
不用pump来传输trail文件时出错，感觉好像是目标端的文件传输不过去
16:42:57&&ERROR& &OGG-01496&&Oracle GoldenGate Capture for Oracle, ext1.prm:&&Failed to open target trail file ./dirdat/lt000000, at RBA 1111.
16:42:57&&ERROR& &OGG-01668&&Oracle GoldenGate Capture for Oracle, ext1.prm:&&PROCESS ABENDING.
exacat文件信息如下：
[oracle@rhel131 dirprm]$ cat ext1.prm
extract ext1
setenv (nls_lang=AMERICAN_AMERICA.WE8ISO8859P1)
userid ogg, password ogg
rmthost 172.17.61.132, mgrport 7809
rmttrail ./dirdat/lt
table scott.test1;
论坛徽章:33
为什么要配成相对路径，还是远程，配成绝对路径啊
金牌会员, 积分 1550, 距离下一级还需 1450 积分
论坛徽章:6
原因找到了
由于老师的文档和例子的目标和源在一台机器上，由我的环境是分开的两台机器
要原库建立extact时，要将
add exttrail ./dirdat/lt, extract ext1
add rmttrail /u01/app/oracle/ogg11/dirdat/lt, extract ext1GoldenGate常用操作 - 推酷
GoldenGate常用操作
整理了下ogg的常用操作命令
1、修改rba,checkpoint
alter EXT_ALO,extseqno 17,extrba 9194144,thread 1
alter EXT_ALO,extseqno 10,extrba 5740032,thread 2
2、修改recovery checkpoint
alter EXT_ALO,ioextseqno 17,ioextrba 9193488,thread 1
EXT_ALO,ioextseqno 10,ioextrba 5739536,thread 2
3、info extract cust_ext, detail
--抽取进程的详细信息
4、info extract ext*, showch
--抽取进程的检查点信息,注意checkpoint和recovery checkpoint
5、INFO TRANDATA user_name.table_names
--表的补充日志
6、常用添加extract命令
ggsci& add extract ext1, tranlog, begin now
ggsci& add extract ext1, tranlog, begin now, threads 4
ggsci& add extract ext1, tranlog, begin now, passive
ggsci& add extract ext1, extseqno 111, begin now
ggsci& add extract ext1, extrba 567890, begin
ggsci& add extract ext1, sourceistable
ggsci& add extract ext1, exttrailsource /oracle/gg11/dirdat/hr
--data pump
ggsci& add extract ext1, vam
-- VAM - Vendor Access Module
ggsci& add extract ext1, vamtrailsource /ogg/dirdat/vt
ggsci& add extract ext1, rmthost host123, mgrport 7810, rmtname fin
ggsci& STATUS MANAGER
-- To determine whether or not the Manager process is running
ggsci& STATUS EXTRACT group_name [, TASKS | ALLPROCESSES]
-- To determine whether or not Extract is running
ggsci& status extract extr_hr
ggsci& status extract ext*, tasks
ggsci& status extract *ext*, allprocesses
ggsci& STATUS REPLICAT group_name [, TASKS | ALLPROCESSES]
-- To determine whether or not Replicat is running
ggsci& status replicat emp_rep
ggsci& status replicat cust_rep, allprocesses
ggsci& STATUS ER group_wildcard_specification
-- To check the status of multiple Extract and Replicat groups as a unit
ggsci& status er *EX*
Reading Program Database management system Vacuum Pump The Word Find email address free
ggsci& STATS EXTRACT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTFETCH | NOREPORTFETCH] [, REPORTRATE HR|MIN|SEC] [, ... ]
-- To display statistics for one or more Extract group
ggsci& stats ext_hr
ggsci& stats extract ext
ggsci& stats extract ext2 reportrate sec
ggsci& stats extract fin, total, daily
ggsci& stats extract fin, total, hourly, table acct, reportrate min, reset, reportfetch
ggsci& SEND MANAGER [CHILDSTATUS [DEBUG]] [GETPORTINFO [DETAIL]] [GETPURGEOLDEXTRACTS]
-- To retrieve the status of the active Manager process or to retrieve dynamic port information as configured in the Manager parameter file
ggsci& send manager childstatus
ggsci& send manager childstatus debug
ggsci& send manager getportinfo
ggsci& send manager getportinfo detail
ggsci& send manager getpurgeoldextracts
ggsci& SEND EXTRACT group_name,
{ CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} | FORCESTOP | FORCETRANS id [THREAD n] [FORCE] | GETLAG | GETTCPSTATS | LOGEND | REPORT | ROLLOVER | SHOWTRANS [id] [THREAD n] [COUNT n] [DURATION duration_unit] [TABULAR] [FILE file_name [DETAIL]] | SKIPTRANS id [THREAD n] [FORCE] | STATUS | STOP | TLTRACE {DEBUG | OFF | level} [SIZELIMIT size] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] {tracefile | OFF} | TRACEINIT | TRANLOGOPTIONS {PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} | TRANLOGOPTIONS TRANSCLEANUPFREQUENCY minutes | VAMMESSAGE &Teradata_command& | VAMMESSAGE {ARSTATS | INCLUDELIST [filter] | EXCLUDELIST [filter]} | VAMMESSAGE OPENTRANS
} -- To communicate with a running Extract process
Teradata_command = {&control:terminate& | &control:suspend& | &control:resume& | &control:copy database.table&
ggsci& send extract exthr status
ggsci& send extract extr, getlag
ggsci& send extract group_name tltrace file file_name ddlinclude
ggsci& send extract fin, rollover
ggsci& send extract fin
ggsci& send extract fin, vammessage control:suspend
ggsci& send extract fin, tranlogoptions transcleanupfrequency 15
ggsci& send extract fin, showtrans count 10
ggsci& send extract fin, skiptrans 5.17.27634 thread 2
ggsci& ALTER EXTRACT group_name [, ADD_EXTRACT_attribute] [, THREAD number] [, ETROLLOVER]
-- To change the attributes of an Extract group, To increment a trail to the next file in the sequence
ggsci& alter extract fin, begin
ggsci& alter extract fin, etrollover
ggsci& alter extract fin, extseqno 26, extrba 338
ggsci& alter extract accounts, thread 4, begin
ggsci& alter extract sales, lsn
ggsci& LAG EXTRACT group_name
-- To determine a true lag time between Extract and the datasource
ggsci& lag extract ext*
ggsci& lag extract *
1、send rep2, NOHANDLECOLLISIONS
--send 命令动态取消HANDLECOLLISIONS
2、info replicat fin, showch --复制进程的检查点信息
3、info replicat emp_rep, detail
--复制进程的相应信息
4、info checkpointtable gg_owner.chkpt_table --检查点表信息
5、常用添加replicat进程命令
ggsci& add replicat repl, exttrail C:\OGG10G\dirdat\lt
ggsci& add replicat repl, exttrail /oracle/gg11/dirdat/lt, checkpointtable gg_owner.checkpoint
ggsci& add replicat initload, specialrun
ggsci& add replicat repl, exttrail /oracle/gg11/dirdat/lt, nodbcheckpoint
ggsci& STATS REPLICAT group_name [, statistic] [, TABLE table] [, TOTALSONLY table_specification] [, REPORTDETAIL | NOREPORTDETAIL] [, REPORTRATE HR|MIN|SEC] [, ... ]
-- To display statistics for one or more Replicat groups
ggsci& stats rep_hr
ggsci& stats replicat fin, total, table acct, reportrate hr, reset, noreportdetail
ggsci& STATS ER group_wildcard_specification
-- To get statistics on multiple Extract and Replicat groups as a unit
ggsci& stats er ext*
ggsci& SEND REPLICAT group_name,
{ FORCESTOP | GETLAG | HANDLECOLLISIONS [table_specification] | NOHANDLECOLLISIONS [table_specification] | REPORT [HANDLECOLLISIONS [table_specification]] | STATUS | STOP | TRACE[2] [DDLINCLUDE | DDL[ONLY]] [FILE] file_name | TRACE[2] OFF | TRACEINIT
-- To communicate with a starting or running Replicat process
ggsci& send replicat fin, handlecollisions
ggsci& send replicat fin, report handlecollisions fin_*
ggsci& send replicat fin, getlag
ggsci& SEND ER group_wildcard_specification
-- To send instructions to multiple Extract and Replicat groups as a unit
ggsci& send er *ext
ggsci& LAG REPLICAT group_name
-- To determine a true lag time between Replicat and the trail
ggsci& lag replicat myrepl
ggsci& lag replicat *
1、INFO EXTTRAIL trail_name
2、info exttrail e:\ogg\dirdat\ex --本地trail文件信息
3、INFO RMTTRAIL trail_name
4、info rmttrail d:\ogg\dirdat\ex --远程trail文件信息
5、常用添加trail 命令
ggsci& ADD EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]
-- To create a trail for online processing on local system
ggsci& add exttrail /oracle/gg11/dirdat/lt, extract s_extr
ggsci& add exttrail C:\OGG10G\dirdat\et, extract emp_ext
ggsci& add exttrail c:\ogg\dirdat\fi, extract fin, megabytes 30
ggsci& ADD RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]
-- To create a trail for online processing on remote system
ggsci& add rmttrail C:\OGG10G\dirdat\hr, extract extr
ggsci& add rmttrail /u01/app/oracle/ogg/dirdat/ms, extract msextr
ggsci& add rmttrail /u01/app/oracle/ogg/dirdat/my, extract mysql, megabytes 50
ggsci& ALTER EXTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]
-- To change the attributes of a trail (on the local system)
ggsci& alter exttrail c:\ogg\dirdat\aa, extract fin, megabytes 30
ggsci& ALTER RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n]
-- To change the attributes of a trail (on a remote system)
ggsci& alter rmttrail c:\ogg\dirdat\et, extract fin, megabytes 25
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
正文不准确
标题不准确
排版有问题
没有分页内容
图片无法显示
视频无法显示
与原文不一致trackbacks-0
Created By BaoXinjian
对GoldenGate实例进行监控，可以公国简单高效的方式GGSCI命令进行监控，并查看返回的信息，判断GoldenGate运行情况是否正常
1. 使用GGSCI命令监控
2. 通过ggserr.log日志监控
3. 通过进入report目录文件监控
4. 日常运维监控自动化脚本
&二、使用GGSCI命令监控
1. info all
(1). 作用：查看整体的运行情况
GGSCI () 5& info all
Lag at Chkpt
Time Since Chkpt
2. view params process
(1). 作用：查看进程的参数设置
GGSCI () 6& view params EXT1
extract ext1
userid ggate@gavinprod, password oracle
, mgrport 7809
rmttrail /opt/oracle/ggate/dirdat/lt
ddl include mapped objname sender.*;
table sender.*;
3. info process
(1). 作用：查看进程的信息性，包括进程的状态、Checkpoint信息、延时等
GGSCI () 7& info EXT1
Last Started 2015-01-28 05:31
Status RUNNING
Checkpoint Lag
529:05:45 (updated 00:00:02 ago)
Log Read Checkpoint
Oracle Redo Logs
2015-01-06 04:27:03
Seqno 24, RBA
SCN 0.1440415 (1440415)
4. info process detail
(1). 作用：查看更加详细的信息，包括所使用的trail文件、参数文件、报告文件、警告文件的位置
GGSCI () 8& info EXT1 detail
Last Started 2015-01-28 05:31
Status RUNNING
Checkpoint Lag
431:32:57 (updated 00:00:04 ago)
Log Read Checkpoint
Oracle Redo Logs
2015-01-10 06:00:18
Seqno 31, RBA
SCN 0.1553661 (1553661)
Target Extract Trails:
Remote Trail Name
/opt/oracle/ggate/dirdat/lt
Extract Source
/opt/oracle/flash_recovery_area/GAVINPROD/archivelog/2015_01_10/o1_mf_1_31_bc2d3p27_.arc
2014-12-24 04:12
2015-01-10 06:00
/opt/oracle/oradata/gavinprod/redo01.log
2014-12-24 00:23
2014-12-24 04:12
Not Available
* Initialized *
2014-12-24 00:23
Current directory
/opt/oracle/ggate
Report file
/opt/oracle/ggate/dirrpt/EXT1.rpt
Parameter file
/opt/oracle/ggate/dirprm/ext1.prm
Checkpoint file
/opt/oracle/ggate/dirchk/EXT1.cpe
Process file
/opt/oracle/ggate/dirpcs/EXT1.pce
Stdout file
/opt/oracle/ggate/dirout/EXT1.out
/opt/oracle/ggate/ggserr.log
5. info process showch
(1). 作用：查看详细的关于checkpoint的细心你想，用于查询GoldenGate进行处理过的事物记录
Extract进程的Recovery checkpoing，他标识源数据最早的未被处理事物，可以查到该事物的redo log位于哪个日志文件以及该日志文件的序列号，所有序列号比它大得日志文件都需保留
GGSCI () 9& info EXT1 showch
Last Started 2015-01-28 05:31
Status RUNNING
Checkpoint Lag
00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint
Oracle Redo Logs
2015-01-28 05:33:32
Seqno 42, RBA 2548736
SCN 0.1750257 (1750257)
Current Checkpoint Detail:
Read Checkpoint #1
Oracle Redo Log
Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 19
Timestamp: 2014-12-24 04:12:21.000000
SCN: 0.1341390 (1341390)
Redo File: /opt/oracle/oradata/gavinprod/redo01.log
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 42
RBA: 2504208
Timestamp: 2015-01-28 05:33:32.000000
SCN: 0.1750256 (1750256)
Redo File: /opt/oracle/oradata/gavinprod/redo03.log
Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 42
RBA: 2548736
Timestamp: 2015-01-28 05:33:32.000000
SCN: 0.1750257 (1750257)
Redo File: /opt/oracle/oradata/gavinprod/redo03.log
Write Checkpoint #1
GGS Log Trail
Current Checkpoint (current write position):
Sequence #: 1
Timestamp: 2015-01-28 05:33:46.462178
Extract Trail: /opt/oracle/ggate/dirdat/lt
CSN state information:
CRC: A4-7E-18-EE
Latest CSN: 1749736
Latest TXN: 7.29.894
Latest CSN of finished TXNs: 1749736
Completed TXNs: 7.29.894
Version = 2
Record Source = A
# Input Checkpoints = 1
# Output Checkpoints = 1
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 3
Transaction Integrity = 1
Task Type = 0
Start Time = 2015-01-28 05:31:39
Last Update Time = 2015-01-28 05:33:46
Stop Status = A
Last Result = 400
6. lag process
(1). 作用：查看详细的延时信息
GGSCI () 10& lag EXT1
Sending GETLAG request to EXTRACT EXT1 ...
Last record lag: 23 seconds.
At EOF, no more records to process.
(1). 作用：查看进程处理的记录数
GGSCI () 13& stats EXT1, total
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2015-01-28 05:37:59.
DDL replication statistics (for all trails):
*** Total statistics since extract started
Operations
Mapped operations
Unmapped operations
Other operations
Excluded operations
Output to /opt/oracle/ggate/dirdat/lt:
Extracting from GGATE.GGS_MARKER to GGATE.GGS_MARKER:
*** Total statistics since 2015-01-28 05:31:45 ***
No database operations have been performed.
End of Statistics.
8. view report process
(1). 作用：查看对应的报告文件
GGSCI () 11& view report EXT1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_0_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:42:16
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2015-01-28 05:31:33
***********************************************************************
Operating System Version:
Version #1 SMP Mon Nov 12 02:14:55 EST 2007, Release 2.6.18-53.el5
Machine: x86_64
soft limit
hard limit
Address Space Size
Process id: 5097
Description:
***********************************************************************
Running with the following parameters
***********************************************************************
2015-01-28 05:31:33
Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
extract ext1
userid ggate@gavinprod, password ******
2015-01-28 05:31:35
WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of AL32UTF8.
, mgrport 7809
rmttrail /opt/oracle/ggate/dirdat/lt
&三、通过ggserr.log日志监控
1. ggserr.log可以查看到的内容
(1). GGSCI命令的历史记录
(2). GoldenGate进程的启动和停止
(3). 已执行的处理
(4). 发生的错误
(5). 信息和警告消息
2. 如何查看 - 通过ggsevt命令
GGSCI () 14& view ggsevt
2014-09-10 01:26:35
Oracle GoldenGate Command Interpreter for Oracle:
GGSCI command (ggate): edit params mgr.
2014-09-10 01:27:16
Oracle GoldenGate Command Interpreter for Oracle:
GGSCI command (ggate): edit params mgr.
2014-09-10 01:27:27
Oracle GoldenGate Command Interpreter for Oracle:
GGSCI command (ggate): start manager.
2014-09-10 01:27:28
Oracle GoldenGate Manager for Oracle, mgr.prm:
Manager started (port 7809).
2014-09-10 01:27:40
Oracle GoldenGate Command Interpreter for Oracle:
GGSCI command (ggate): add extract ext1
tranlog, begin now.
2014-09-10 01:29:24
Oracle GoldenGate Command Interpreter for Oracle:
GGSCI command (ggate): add exttrail2014-09-10 02:24:03
2014-09-10 02:24:03
Oracle GoldenGate Manager for Oracle, mgr.prm:
Manager started (port 7809).
2014-09-10 02:24:07
Oracle GoldenGate Command Interpreter for Oracle:
GGSCI command (ggate): start EXT1.
2014-09-10 02:24:07
Oracle GoldenGate Manager for Oracle, mgr.prm:
Command received from GGSCI on
2014-09-10 02:24:07
Oracle GoldenGate Manager for Oracle, mgr.prm:
EXTRACT EXT1 starting.
2014-09-10 02:24:08
Oracle GoldenGate Capture for Oracle, ext1.prm:
EXTRACT EXT1 starting.
2014-09-10 02:24:08
Oracle GoldenGate Capture for Oracle, ext1.prm:
Operating system character set identified as UTF-8.
2014-09-10 02:24:19
Oracle GoldenGate Capture for Oracle, ext1.prm:
BOUNDED RECOVERY: reset to initial or altered checkpoint.
2014-09-10 02:24:19
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:
/opt/oracle/ggate/BR/EXT1.
2014-09-10 02:24:19
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:
/opt/oracle/ggate/dirtmp.
2014-09-10 02:24:20
WARNING OGG-01423
Oracle GoldenGate Capture for Oracle, ext1.prm:
No valid default archive log destination directory found
3. 如可查看 - 通过gserr.log文件
[ggate@gavinprod ggate]$ pwd
/opt/oracle/ggate
[ggate@gavinprod ggate]$ ls ggserr.log
ggserr.log
&四、通过进入report目录文件监控
1. 通过report文件
[ggate@gavinprod dirrpt]$ pwd
/opt/oracle/ggate/dirrpt
[ggate@gavinprod dirrpt]$ ls -ltr
-rw-rw-rw- 1 ggate
1182 Sep 10 01:27 MGR3.rpt
-rw-rw-rw- 1 ggate
1721 Sep 10 02:24 MGR2.rpt
-rw-rw-rw- 1 ggate
1721 Sep 16 19:06 MGR1.rpt
-rw-rw-rw- 1 ggate
4242 Sep 16 19:06 EXT19.rpt
-rw-rw-rw- 1 oracle oinstall 21926 Dec 23 23:52 EXT18.rpt
-rw-rw-rw- 1 oracle oinstall 20432 Dec 23 23:56 EXT17.rpt
2. 通过discard文件
[ggate@gavinprod dirrpt] $ pwd
/opt/oracle/ggate/dirrpt
[ggate@gavinprod dirrpt] $ ls *dsc
[ggate@gavinprod dirrpt] $ cat REP1.dsc
OCI Error ORA-00001: unique constraint (RECEIVER.GAVIN_TEST) violated (status = 1), SQL &INSERT INTO "RECEIVER"."GAVIN_TEST" ("ID","TEST_DATE","TEST_DESCRIPTION") VALUES (:a0,:a1,:a2)&
Operation failed at seqno 388 rba
Discarding record on action DISCARD on error 1
Problem replicating SENDER.GAVIN_TEST to RECEIVER.GAVIN_TEST
Mapping problem with insert record (target format)...
TEST_DATE = 2015-01-24 20:29:12
TEST_DESCRIPTION = GAVIN TEST OGG DISCARD
&五、日常运维监控自动化脚本
&GoldenGate可运行监控脚本，用以监控OGG日常状态，和当前以及需要的归档号码
Thanks and Regards
阅读(...) 评论()当前位置： >
OGG data pump进程不投递问题
来源：Ask Oracle社区/栏目：/时间：/阅读：次
前几日对某客户进行OGG平台进行重建，由于前期已经重建过一次，所以按照之前重建的记录删除源库的抽取和投递进程之后重新进行了添加，相关操作如下: 1、停止所有进程： stop * 2、删除进程 delete * 3、重新配置相关进程 GGSCI (rac01) 24 add extract zlext
前几日对某客户进行OGG平台进行重建，由于前期已经重建过一次，所以按照之前重建的记录删除源库的抽取和投递进程之后重新进行了添加，相关操作如下:1、停止所有进程：stop *2、删除进程delete *3、重新配置相关进程GGSCI (rac01) 24& add extract zlext, tranlog, begin now,threads 3
EXTRACT added.
GGSCI (rac01) 25& add exttrail /u01/app/ogg/dirdat/zl extract zlext MEGABYTES 1000
EXTTRAIL added.
GGSCI (rac01) 26& add extract zlpump,exttrailsource /u01/app/ogg/dirdat/
EXTRACT added.
GGSCI (rac01) 27& add rmttrail D:\ogg\dirdat\pt,extract zlpump,megabytes 1000
RMTTRAIL added.然后记录好此时的时间和SCN号准备导出数据。同时对目标库进行重建，创建初始化完成后，发现源库MGR和EXTRACT进程正常，DATA&PUMP进程状态显示也为running，但是却没有进行投递，没有相关错误，只有告警显示为： 10:24:32
Socket buffer size set to 27985 (flush size 27985).
No recovery is required for target file D:\ogg\dirdat\pt000000, at RBA 0 (file not opened).
Output file D:\ogg\dirdat\pt is using format RELEASE 11.2除此之外没有其他信息，反复检查MGR日志和GGSERR.LOG日志后均没有发现什么异常。此时对目标库MGR进程进行检查，均未见任何异常。无奈使用百度+谷歌大法，对DATA&PUMP进程的告警信息进行查询，根据查询的结果汇总不能正常投递的原因有以下两点：1、字符集问题：即源库和目标库的字符集不同，导致无法投递，调整源库字符集后仍无法投递；2、添加DATA&PUMP进程是指定的投递或源目录错误或相应目录权限不够，导致无法投递，重新删除，反复检查，然后添加之后，并对相应目录权限进行核实均没有问题，均不能投递；这个时候我的想法是既然是DATA&PUMP进程无法投递，那么我们就先检查DATA&PUMP进程的状态、参数等，首先对参数进行检查：GGSCI (rac01) 1& view param zlpump
dynamicresolution
numfiles 3000
rmthost 192.168.31.133,mgrport 7809,compress
rmttrail D:\ogg\dirdat\pt
table ZLHIS.*;
TABLE zltools.*;可见参数非常简单，核对后发现不存在有配置错误的地方。然后我在对ZLPUMP进程的状态进行了检查：&GGSCI (rac01) 2& info zlpump
Last Started
Status RUNNING
Checkpoint Lag
00:00:03 (updated 00:00:00 ago)
Log Read Checkpoint
File /u01/app/ogg/dirdat/zl000000
11:28:13.000000
RBA 0此时发现问题了，ZLPUMP进程获取的源的队列文件居然是0号队列文件，而抽取进程ZLEXT由于是重建，重新开始抽取的队列文件号为2086。由此我们就找到原因了，手动指定下ZLPUMP进程获取的队列文件号：1、停止ZLPUMP进程&stop zlpump；2、重新指定队列号：alter zlpump,extseqno 2086,extrba 0；操作后查询ZLPUMP进程状态：GGSCI (rac01) 2& info zlpump
Last Started
Status RUNNING
Checkpoint Lag
00:00:03 (updated 00:00:00 ago)
Log Read Checkpoint
File /u01/app/ogg/dirdat/zl002086
11:28:13.000000
RBA 发现已经正常。然后去目标库进行检查发现投递正常，队列文件已经开始投递，至此DATA&PUMP进程无法投递的问题得以解决。&
个人微信，欢迎来访。
还在犹豫什么，扫起！
Oracle数据库中表空间的数据文件在基于OS系统级别被rm -rf 删除后,只要数据库在删除后一直未被sh...
关于数据库 alter system switch logfile hang住的解决方案 当我执行alter system switch logfil...
sys@ORA10Gconn /as sysdbaConnected.sys@ORA10Gcreate user aaa identified by aaa account unl...
服务器型号：DELL XXXX 内存大小：6G 硬盘空间：300G 系统版本：Red Hat Enterprise Linux 6 32...
检索数据库时，在alert.log日志中发现如下错误： ORA-00600: 内部错误代码, 参数: [qerrmObnd1],...
扫描二维码！轻松学习Oracle！