Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

70

积分

0

好友

22

主题
发表于 2015-3-27 17:18:48 | 查看: 6062| 回复: 2
本帖最后由 swgsw 于 2015-3-27 17:23 编辑

节点一(源)

操作系统版本:hpux 11.31
节点数:4
数据库类型:Rac
DB版本: 10.2.0.5


节点二(目标)

操作系统版本:OEL 6.5 64bit
数据库类型:单实例
DB版本: 11.2.0.4



Oracle GoldenGate Veridata 部署在< 节点二> 上面

版本:11.2.1.0  OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625


比较源和目标的同一张表 报错

两个表均有主键


2015-03-27 03:00:38 Agent message (999): Expected inflated size to be 72 but got 71

Comparison terminated with errors.

望大家指点迷津!
ogg.jpg
发表于 2015-3-27 19:12:33
一些疑问

1、安装 Java Agent on a UNIX or Linux System

agent.properties文件内容中

database.url=  这个串填写的是 源端数据库连接串还是 veridata 库的连接串?

回复 显示全部楼层 道具 举报

发表于 2015-3-28 01:07:13
跟踪了一下

源端的 veridata-agent.log 在运行  job 的比对时候 有一条关于 Could not set the Session Time Zone to 'GMT+08:00' 的警告。
这个有关系吗?

INFO:2015-03-27 23:53:59,088 (Session: 17) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:53:59,089 (Session: 17) - user 'veridata' connected to 'Oracle Database 10g Enterprise Edition Release 10.2.
0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:00,436 (Session: 17) - Starting source initial compare for BUSINESS.J_GRZHB [RowHashQuery:call, line 68]
INFO:2015-03-27 23:54:03,306 () - Starting session 18 [VeridataAgent$Handler:run, line 313]
WARN:2015-03-27 23:54:03,379 (Session: 18) - Could not set the Session Time Zone to 'GMT+08:00' [OracleDatabase:connect, line 1
745]
INFO:2015-03-27 23:54:03,380 (Session: 18) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:54:03,380 (Session: 18) - user 'veridata' connected to 'Oracle Database 10g Enterprise Edition Release 10.2.
0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:03,675 (Session: 18) - Session 18 stopped [VeridataAgent$Handler:run, line 371]
INFO:2015-03-27 23:54:03,910 (Session: 17) - Session 17 stopped [VeridataAgent$Handler:run, line 371]

目标端 veridata-agent.log 在运行  job 后内容如下:

INFO:2015-03-27 23:54:00,207 () - Starting session 29 [VeridataAgent$Handler:run, line 313]
INFO:2015-03-27 23:54:00,208 (Session: 29) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:54:00,209 (Session: 29) - user 'veridata' connected to 'Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:00,467 (Session: 29) - Starting target initial compare for BXBIZ.J_GRZHB [RowHashQuery:call, line 68]
INFO:2015-03-27 23:54:03,426 () - Starting session 30 [VeridataAgent$Handler:run, line 313]
INFO:2015-03-27 23:54:03,460 (Session: 30) - Driver version: 11.2.0.3.0 [AbstractDatabaseConnection:getVersion, line 295]
INFO:2015-03-27 23:54:03,461 (Session: 30) - user 'veridata' connected to 'Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options' [AbstractDatabaseConnection:login, line 1380]
INFO:2015-03-27 23:54:03,696 (Session: 30) - Session 30 stopped [VeridataAgent$Handler:run, line 371]
INFO:2015-03-27 23:54:03,959 (Session: 29) - Session 29 stopped [VeridataAgent$Handler:run, line 371]
INFO:2015-03-27 23:54:04,107 (Session: 29) - Processed 222912 rows and waited on full queue: 0 [RowHashQuery:call, line 232]

回复 显示全部楼层 道具 举报

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

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-3-28 16:17 , Processed in 0.050547 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569