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

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

351

积分

0

好友

8

主题
1#
发表于 2012-4-19 09:23:04 | 查看: 3111| 回复: 0
官方文档的透明网关配置中有这么一步“Configure Two-Phase Commit”

The gateway supports the following transaction capabilities:
  • COMMIT_CONFIRM
  • READ_ONLY
  • SINGLE_SITE
The transaction model is set using the HS_TRANSACTION_MODEL initialization parameter. By default, the gateway runs in COMMIT_CONFIRM transaction mode. When the SQL Server database is updated by a transaction, the gateway becomes the commit point site. The Oracle database commits the unit of work in the SQL Server database after verifying that all Oracle databases in the transaction have successfully prepared the transaction. Only one gateway instance can participate in an Oracle two-phase commit transaction as the commit point site.
To enable the COMMIT_CONFIRM transaction mode, perform the following tasks:
Create a Recovery Account and Password
Create the Transaction Log Table
The log table, called HS_TRANSACTION_LOG, is where two-phase commit transactions are recorded.

1.这一步是做什么用的,我现在没有配置也可以做提交和回滚,如果不配置这一步会有什么负面影响吗?
2.“By default, the gateway runs in COMMIT_CONFIRM transaction mode....To enable the COMMIT_CONFIRM transaction mode, perform the following tasks”
都说了默认是COMMIT_CONFIRM了,还需要配置干嘛?

[ 本帖最后由 gdpr-dba 于 2012-4-19 09:26 编辑 ]
您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-11-15 13:24 , Processed in 0.054768 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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