2022-04-29 09:33:20 ERROR OGG-00446 Redo sequence 362029 no longer available in online logs for thread 1 without archiving enabled, SQL <SELECT MAX(sequence#) FROM v$log
WHERE thread# = :ora_thread>, error retrieving redo file name for sequence 362029, archived = 0, use_alternate = 0Not able to establish initial position for sequence 362029,
rba 429407760.
处理办法：
由于该机器的归档已丢失，无法找回，允许丢失部分数据(不允许丢失或无法补全数据的话，需要重新同步相关表https://www.modb.pro/db/187459)，从新的日志点开始抽取，修改推送队列起始文件，否则不会报错也不继续推送。
检查select * from v$Log;查看最早时间日志。
抽取进程：
alter extract E247,begin 2022-04-29 08:00:27
ALTER EXTRACT E247, etrollover
start E247
info e247
info all
推送进程：
stop p95a
stop p95b
ALTER EXTRACT p95a, EXTSEQNO 2312, EXTRBA 0
ALTER EXTRACT p95b, EXTSEQNO 2312, EXTRBA 0
start p95a
start p95b
info all
info p95a
info p95b
相关知识：https://sqlora.blog.csdn.net/article/details/89633533
alter extract E247, extseqno 363180, extrba 0
ALTER EXTRACT E247, etrollover
OGG常用操作：
https://sqlora.blog.csdn.net/article/details/89633567
操作记录：
2022-04-29 09:41:17 INFO OGG-01515 Positioning to begin time 2022-4-29 上午7:29:27.
Source Context :
SourceModule : [gglib.ggdatasource.DataSource]
SourceID : [/scratch/mmar/view_storage/mmar_27982919/oggcore/OpenSys/src/gglib/ggdatasource/DataSource.cpp]
SourceFunction : [establishStartPoint]
SourceLine : [175]
ThreadBacktrace : [11] elements
: [/ogg/12c/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f419bbba72b]]
: [/ogg/12c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f419bbb47f4]]
: [/ogg/12c/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x30) [0x7f419bba1dc3]]
: [/ogg/12c/extract(ggs::gglib::ggdatasource::DataSource::establishStartPoint(time_elt_def&, time_elt_def&)+0xef) [0x88c35f]]
: [/ogg/12c/extract() [0x5f62a1]]
: [/ogg/12c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d3d80]]
: [/ogg/12c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d4ffd]]
: [/ogg/12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d50e1]]
: [/ogg/12c/extract(main+0x3b) [0x5f771b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x331161ed5d]]
: [/ogg/12c/extract() [0x5646d9]]
2022-04-29 09:41:41 ERROR OGG-00446 Redo sequence 363178 no longer available in online logs for thread 1 without archiving enabled, SQL <SELECT MAX(sequence#) FROM v$log
WHERE thread# = :ora_thread>, error retrieving redo file name for sequence 363178, archived = 1, use_alternate = 0Not able to establish initial position for begin time 2022-
04-29 07:29:27.000000.
2022-04-29 09:41:41 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (hxplatformdbnew) 25> alter extract E247,begin 2022-04-29 08:00:27
EXTRACT altered.
GGSCI (hxplatformdbnew) 26> ALTER EXTRACT E247, etrollover
2022-04-29 09:42:37 INFO OGG-01520 Rollover performed. For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.
EXTRACT altered.
GGSCI (hxplatformdbnew) 27>
GGSCI (hxplatformdbnew) 29> start e247
Sending START request to MANAGER ...
EXTRACT E247 starting
GGSCI (hxplatformdbnew) 30> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 01:42:26 00:00:00
EXTRACT RUNNING P95A 00:00:00 00:00:00
EXTRACT RUNNING P95B 00:00:00 00:00:00
REPLICAT RUNNING R_GDDB 00:00:00 00:00:00
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:00
GGSCI (hxplatformdbnew) 34> info e247
EXTRACT E247 Last Started 2022-04-29 09:42 Status RUNNING
Checkpoint Lag 01:41:21 (updated 00:00:06 ago)
Process ID 31619
Log Read Checkpoint Oracle Redo Logs
2022-04-29 08:01:42 Seqno 363204, RBA 74436
SCN 4077.1042993580 (17511624659372)
GGSCI (hxplatformdbnew) 35> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 01:41:21 00:00:09
EXTRACT RUNNING P95A 00:00:00 00:00:00
EXTRACT RUNNING P95B 00:00:00 00:00:00
REPLICAT RUNNING R_GDDB 00:00:00 00:00:03
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:03
GGSCI (hxplatformdbnew) 36> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:22:13 00:00:02
EXTRACT RUNNING P95A 00:00:00 00:00:03
EXTRACT RUNNING P95B 00:00:00 00:00:03
REPLICAT RUNNING R_GDDB 00:00:00 00:00:06
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:06
GGSCI (hxplatformdbnew) 38> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:22:13 00:00:06
EXTRACT RUNNING P95A 00:00:00 00:00:07
EXTRACT RUNNING P95B 00:00:00 00:00:07
REPLICAT RUNNING R_GDDB 00:00:00 00:00:00
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:00
GGSCI (hxplatformdbnew) 40> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:00:00 00:00:01
EXTRACT RUNNING P95A 00:00:00 00:00:02
EXTRACT RUNNING P95B 00:00:00 00:00:02
REPLICAT RUNNING R_GDDB 00:00:00 00:00:02
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:02
GGSCI (hxplatformdbnew) 42> info e247
EXTRACT E247 Last Started 2022-04-29 09:42 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 31619
Log Read Checkpoint Oracle Redo Logs
2022-04-29 09:43:19 Seqno 363210, RBA 323028480
SCN 4077.1048496970 (17511630162762)
GGSCI (hxplatformdbnew) 45> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:00:00 00:00:05
EXTRACT RUNNING P95A 00:00:00 00:00:09
EXTRACT RUNNING P95B 00:00:00 00:00:09
REPLICAT RUNNING R_GDDB 00:00:36 00:00:00
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:03
GGSCI (hxplatformdbnew) 47> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:00:00 00:00:08
EXTRACT RUNNING P95A 00:00:00 00:00:09
EXTRACT RUNNING P95B 00:00:00 00:00:09
REPLICAT RUNNING R_GDDB 00:00:00 00:00:00
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:01
GGSCI (hxplatformdbnew) 48> info e247
EXTRACT E247 Last Started 2022-04-29 09:42 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 31619
Log Read Checkpoint Oracle Redo Logs
2022-04-29 10:24:46 Seqno 363215, RBA 120722432
SCN 4077.1050743493 (17511632409285)
GGSCI (hxplatformdbnew) 49> info p95b
EXTRACT P95B Last Started 2021-12-30 21:14 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Process ID 15796
Log Read Checkpoint File ./dirdat/ex002310
2022-04-27 16:32:50.000000 RBA 92203903
GGSCI (hxplatformdbnew) 50> info p95a
EXTRACT P95A Last Started 2022-04-22 09:56 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Process ID 22828
Log Read Checkpoint File ./dirdat/ex002310
2022-04-27 16:32:50.000000 RBA 92203903
GGSCI (hxplatformdbnew) 52> stop p95a
Sending STOP request to EXTRACT P95A ...
stop p95b
Request processed.
GGSCI (hxplatformdbnew) 53>
Sending STOP request to EXTRACT P95B ...
Request processed.
GGSCI (hxplatformdbnew) 54>
GGSCI (hxplatformdbnew) 54> ALTER EXTRACT p95a, EXTSEQNO 2312, EXTRBA 0
EXTRACT altered.
GGSCI (hxplatformdbnew) 55> ALTER EXTRACT p95b, EXTSEQNO 2312, EXTRBA 0
EXTRACT altered.
GGSCI (hxplatformdbnew) 56> start p95a
Sending START request to MANAGER ...
EXTRACT P95A starting
GGSCI (hxplatformdbnew) 57> start p95b
Sending START request to MANAGER ...
EXTRACT P95B starting
GGSCI (hxplatformdbnew) 58> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:00:00 00:00:04
EXTRACT RUNNING P95A 00:00:00 00:00:09
EXTRACT RUNNING P95B 00:00:00 00:00:08
REPLICAT RUNNING R_GDDB 00:00:00 00:00:02
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:01
GGSCI (hxplatformdbnew) 59> info p95a
EXTRACT P95A Last Started 2022-04-29 10:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 5950
Log Read Checkpoint File ./dirdat/ex002312
First Record RBA 0
GGSCI (hxplatformdbnew) 60> info p95b
EXTRACT P95B Last Started 2022-04-29 10:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 5960
Log Read Checkpoint File ./dirdat/ex002312
2022-04-29 10:29:30.000000 RBA 29406498
GGSCI (hxplatformdbnew) 61> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E247 00:00:00 00:00:00
EXTRACT RUNNING P95A 00:00:00 00:00:02
EXTRACT RUNNING P95B 00:00:00 00:00:02
REPLICAT RUNNING R_GDDB 00:00:00 00:00:04
REPLICAT RUNNING R_GDDBKX 00:00:00 00:00:04
GGSCI (hxplatformdbnew) 62> info r_gddb
REPLICAT R_GDDB Last Started 2021-11-04 19:47 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 13183
Log Read Checkpoint File /ogg/12c/dirdat/gd015964
2022-04-29 10:29:32.006780 RBA 801968
GGSCI (hxplatformdbnew) 64> info p95a
EXTRACT P95A Last Started 2022-04-29 10:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 5950
Log Read Checkpoint File ./dirdat/ex002312
2022-04-29 10:30:03.000000 RBA 29527804
GGSCI (hxplatformdbnew) 65> info p95b
EXTRACT P95B Last Started 2022-04-29 10:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Process ID 5960
Log Read Checkpoint File ./dirdat/ex002312
2022-04-29 10:30:03.000000 RBA 29527804
GGSCI (hxplatformdbnew) 66>
最后修改时间：2022-05-04 15:38:27
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
