联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有客户delete删除了myisam表中的部分数据,本来表中4-5w条记录,删除之后值剩余几十条,希望对其进行恢复（该库没有开启binlog）
mysql> select count(1) from db_bet; +----------+ | count(1) | +----------+ | 46 | +----------+ 1 row in set (0.00 sec)
通过分析.MYD文件确认数据依旧在文件中
mysql> select count(1) from db_bet_deleted; +----------+ | count(1) | +----------+ | 40158 | +----------+ 1 row in set (0.10 sec)
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：OGG-01777 Extract abended as it ran out of sequence numbers used to create TRAIL files
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
ogg extract 进程报OGG-01777 Extract abended as it ran out of sequence numbers used to create TRAIL files. The maximum number of TRAIL files allowed is 999999.
--ggsci中执行
edit param eora_1
--修改文件
EXTTRAIL ./dirdat/ab
--ggsci中执行
delete exttrail ./dirdat/aa extract eora_1
add exttrail ./dirdat/ab extract eora_1
GGSCI (xff-source) 51> info eora_1
EXTRACT EORA_1 Last Started 2022-11-24 22:59 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Log Read Checkpoint Oracle Redo Logs
First Record Seqno 248386, RBA 0
SCN 0.0 (0)
修改extract pump进程
edit params PORA_1
rmttrail ./dirdat/pc
delete rmttrail ./dirdat/pa extract PORA_1
add rmttrail ./dirdat/pc extract PORA_1
alter ext PORA_1 exttrailsource ./dirdat/ab
GGSCI (xff-source) 56> info pora_1
EXTRACT PORA_1 Initialized 2022-11-24 22:59 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:01:37 ago)
Log Read Checkpoint File ./dirdat/ab000000
First Record RBA 0
replcat进程处理
alter rep rep1 exttrail ./dirdat/pc
GGSCI (xff-target) 9> info rep1
REPLICAT REP1 Initialized 2022-11-24 23:00 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint File ./dirdat/pb000000
First Record RBA 0
启动相关进程进行传输即可.
另外可以考虑相对简单一点操作,直接delete/add exttrail，delete/add rmttrail同名文件,省去修改param文件的麻烦,注意最终找trail文件名称和偏移量是否准确,如果不正确注意使用类似命令修改
add exttrail ./dirdat/xx, extract xxx, megabytes 1024 add rmttrail ./dirdat/xx, megabytes 1024, seqno 0 , rba 0, extract xxx alter replicat xxx, extseqno 0, extrba 0 alter extract xxx，extseqno xxxx，extrba xxxx
 |
|