今天客户一个OGG extract进程STOPED了,查看日志报归档无法找见,出现此种情况往往是归档已经备走或被删除。通常解决的办法有三种:1.查看要传输的数据是否正常。如果正常可以考虑修改extract 进程为begin now来从当前时间开始做捕获或传输。2.如果数据库不准确,需要采用RMAN的方式,还原归档来达到目的。3.修改Recovery Checkpoint 对应的时间戳为Current Checkpoint 对应的时间戳
问题症状:
Source Context :
SourceModule : [er.main]
SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#25 $]
SourceFunction : [extract_start_point(time_elt_def *, time_elt_def *)]
SourceLine : [12057]
2014-11-07 15:17:33 GGS ERROR 500 Could not find archived log for sequence 5237 thread 1 under default destinations SQL WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND archived = 'YES' AND deleted = 'NO' AND name not like '+%' AN>, erro
r retrieving redo file name for sequence 5237, archived = 1, use_alternate = 0Not able to establish initial position for sequence 5237, rba 2742800.
2014-11-07 15:17:33 GGS ERROR 190 PROCESS ABENDING.
解决方法:
1. 第一种解决方法:
GGSCI>alter extract ext1,begin now
GGSCI>start ext1
2. 第二种解决方法:
--通过RMAN来还原归档
rman target /
run {
allocate channel t1 type 'sbt_tape'
parms 'ENV=(NSR_SERVER=backupsvr4,NSR_DATA_VOLUME_POOL=TXY3archdata)';
restore archivelog from logseq 5237 until logseq 5239;
release channel t1;}
---还原后再开始OGG进程
GGSCI>start ext1
3.第三种解决方法
GGSCI>info ext1 ----查找出seq 5237对应的时间
GGSCI>alter extract ext1 ,begin 2014-11-07
GGSCI>start ext1
查看进程:
GGSCI (sokf6a) 132>info SDSEQ,showch
info *
alter extract sdseq ,thread 1,extseqno 7246, extrba 1275700736
alter extract sdseq ,thread 2,extseqno 16139, extrba 3049684856
问题症状:
Source Context :
SourceModule : [er.main]
SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#25 $]
SourceFunction : [extract_start_point(time_elt_def *, time_elt_def *)]
SourceLine : [12057]
2014-11-07 15:17:33 GGS ERROR 500 Could not find archived log for sequence 5237 thread 1 under default destinations SQL WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND archived = 'YES' AND deleted = 'NO' AND name not like '+%' AN>, erro
r retrieving redo file name for sequence 5237, archived = 1, use_alternate = 0Not able to establish initial position for sequence 5237, rba 2742800.
2014-11-07 15:17:33 GGS ERROR 190 PROCESS ABENDING.
解决方法:
1. 第一种解决方法:
GGSCI>alter extract ext1,begin now
GGSCI>start ext1
2. 第二种解决方法:
--通过RMAN来还原归档
rman target /
run {
allocate channel t1 type 'sbt_tape'
parms 'ENV=(NSR_SERVER=backupsvr4,NSR_DATA_VOLUME_POOL=TXY3archdata)';
restore archivelog from logseq 5237 until logseq 5239;
release channel t1;}
---还原后再开始OGG进程
GGSCI>start ext1
3.第三种解决方法
GGSCI>info ext1 ----查找出seq 5237对应的时间
GGSCI>alter extract ext1 ,begin 2014-11-07
GGSCI>start ext1
查看进程:
GGSCI (sokf6a) 132>info SDSEQ,showch
info *
alter extract sdseq ,thread 1,extseqno 7246, extrba 1275700736
alter extract sdseq ,thread 2,extseqno 16139, extrba 3049684856
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29446986/viewspace-1324296/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29446986/viewspace-1324296/