|
GGSCI (iZ23g5p9kd3Z) 10> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT ABENDED EORA 00:00:00 18:59:24 EXTRACT RUNNING PUMP_SO 00:00:00 00:00:04 EXTRACT STOPPED WORA 00:00:00 956:27:55 GGSCI (iZ23g5p9kd3Z) 11> GGSCI (iZ23g5p9kd3Z) 13> view report eora 0013F376B48]] : [D:\ogg\extract.exe(ERCALLBACK+0x434ab) [0x000000013 F27C8FB]] : [D:\ogg\extract.exe(CommonLexerNewSSD+0xef32) [0x000 000013F5A2622]] : [C:\Windows\system32\kernel32.dll(BaseThreadInitThun k+0xd) [0x0000000076C959CD]] : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x 21) [0x0000000076DCB891]] 2017-04-25 13:41:52 ERROR OGG-00446 Could not find archived log for sequence 5120 thread 1 under default destinations SQL <SELECT name FROM v$archived_l og WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND delete d = 'NO' AND name not like '+%' AND standby_dest = 'NO' >, error retrieving redo file name for sequence 5120, archived = 1, use_alternate = 0Not able to establish initial position for sequence 5120, rba 1650192. 2017-04-25 13:41:52 ERROR OGG-01668 PROCESS ABENDING. GGSCI (iZ23g5p9kd3Z) 14> 归档日志被删除导致的，抽取进程找不到日志，抽取进程退出（原因由于服务晚上被重启了，导致ogg进程停掉了，oracle rman备份后把归档日志清掉了） 恢复归档日志： RMAN> restore archivelog from logseq 5119 until logseq 5126; 启动 restore 于 25-4月 -17 分配的通道: ORA_DISK_1 通道 ORA_DISK_1: SID=18 设备类型=DISK 通道 ORA_DISK_1: 正在开始将归档日志还原到默认目标 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5119 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5120 通道 ORA_DISK_1: 正在读取备份片段 D:\APP\RMAN\DATABASE\20170425\FQS2HH4R_1_1.ARC 通道 ORA_DISK_1: 段句柄 = D:\APP\RMAN\DATABASE\20170425\FQS2HH4R_1_1.ARC 标记 = TAG20170425T010426 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:00:07 通道 ORA_DISK_1: 正在开始将归档日志还原到默认目标 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5121 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5122 通道 ORA_DISK_1: 正在读取备份片段 D:\APP\RMAN\DATABASE\20170425\FRS2HH4U_1_1.ARC 通道 ORA_DISK_1: 段句柄 = D:\APP\RMAN\DATABASE\20170425\FRS2HH4U_1_1.ARC 标记 = TAG20170425T010426 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:00:08 通道 ORA_DISK_1: 正在开始将归档日志还原到默认目标 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5123 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5124 通道 ORA_DISK_1: 正在读取备份片段 D:\APP\RMAN\DATABASE\20170425\FSS2HH50_1_1.ARC 通道 ORA_DISK_1: 段句柄 = D:\APP\RMAN\DATABASE\20170425\FSS2HH50_1_1.ARC 标记 = TAG20170425T010426 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:00:15 通道 ORA_DISK_1: 正在开始将归档日志还原到默认目标 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5125 通道 ORA_DISK_1: 正在还原归档日志 归档日志线程=1 序列=5126 通道 ORA_DISK_1: 正在读取备份片段 D:\APP\RMAN\DATABASE\20170425\FTS2HH52_1_1.ARC 通道 ORA_DISK_1: 段句柄 = D:\APP\RMAN\DATABASE\20170425\FTS2HH52_1_1.ARC 标记 = TAG20170425T010426 通道 ORA_DISK_1: 已还原备份片段 1 通道 ORA_DISK_1: 还原完成, 用时: 00:00:07 完成 restore 于 25-4月 -17 RMAN> 在次启动抽取进程，数据同步正常 GGSCI (iZ23g5p9kd3Z) 17> start eora Sending START request to MANAGER ('GGMGR') ... EXTRACT EORA starting GGSCI (iZ23g5p9kd3Z) 18> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EORA 00:00:00 00:00:03 EXTRACT RUNNING PUMP_SO 00:00:00 00:00:09 EXTRACT STOPPED WORA 00:00:00 956:47:32 |
|
|
