求助 ggs error 500

[复制链接]
查看11 | 回复3 | 2011-4-24 11:15:31 | 显示全部楼层 |阅读模式
源端是双机热备,从主机切换到备机上gg的所有抽取进程都起不来,报错信息如下
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
2011-04-24 11:15:31.319Redo thread 1:
2011-04-24 11:15:31.319Redo thread 1: Default destinations: count 1
2011-04-24 11:15:31.319Redo thread 1:
2011-04-24 11:15:31.319Redo thread 1:
2011-04-24 11:15:31.319Redo thread 1: Default format
2011-04-24 11:15:31.319Redo thread 1:
2011-04-24 11:15:31.319Redo thread 1: No alternative log format for thread 1 was established
2011-04-24 11:15:31.319Redo thread 1:
2011-04-24 11:15:31.319Redo thread 1: Alternative formats from other threads: count 0
2011-04-24 11:15:31.319Redo thread 1: Not able to establish initial position for sequence 110877, rba 2064.
Source Context :
SourceModule
: [er.main]
SourceID
: [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#19 $]
SourceFunction
: [extract_start_point]
SourceLine
: [12032]
2011-04-24 11:15:31GGS ERROR 500Could not find archived log for sequence 110877 thread 1 under default destinations SQL , error retrieving redo file name for sequence 110877, archived
= 1, use_alternate = 0Not able to establish initial position for sequence 110877, rba 2064.
2011-04-24 11:15:31GGS ERROR 190PROCESS ABENDING.
投递进程和目标端 应用进程都没问题。。。
求助。。。
回复

使用道具 举报

千问 | 2011-4-24 11:15:31 | 显示全部楼层
问题很明显啊,相应的归档日至找不到!你看看主备切换后归档日志哪里去了
回复

使用道具 举报

千问 | 2011-4-24 11:15:31 | 显示全部楼层
哦 谢谢!!! 问题找到了是找不到归档日志了。。。

现在源端和目标端时间差异有30个小时如果把归档找回来 gg可以重新读这段时间的日志来恢复目标端的数据吗?
回复

使用道具 举报

千问 | 2011-4-24 11:15:31 | 显示全部楼层
有备份吗,从备份中恢复,或者找找你归到哪里了,cp到新的归档目录下即可
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行