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

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

0

积分

1

好友

48

主题
1#
发表于 2012-12-29 15:38:24 | 查看: 2829| 回复: 1
在看到Oracle® GoldenGate
Windows and UNIX Administrator’s Guide
11g Release 1 Patch Set 1 (11.1.1.1)
E21513-01
文档里说明trail file 格式的解释的时候对IO Time的说明如下:
IO Time
The timestamp of the commit record, in local time of the source
system, in GMT format. All records in a transaction will have the
same commit timestamp. The combination of IO Time and AuditRBA
uniquely identifies data from a given transaction

IO Time 和AuditRBA加起来可以唯一确定某个事务里的数据,也就是说这两个加起来是唯一确定事务的标记

我在想,如果两个事务同时进行,然后他们在同一个时间点commit,那么IO Time会不会就一样了呢,那怎么区分唯一性呢
2#
发表于 2012-12-29 21:27:37
AuditRBA

For some data sources, such as NonStop, this is the relative byte address of the commit
record. In this case all records in a transaction will have the same commit relative byte
address. IO Time + AuditRBA uniquely identifies data for that transaction.

IO Time
The timestamp of the commit record, in local time of the source
system, in GMT format. All records in a transaction will have the
same commit timestamp.


不存在2个事务 的commit timestamp+ rba地址 一致的可能

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-5-19 16:20 , Processed in 0.045913 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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