OSYNC命令行使用

OSYNC是基于Oracle直接路径接口的数据库全表导出、导入工具，采用多线程方式同时复制多张表，具有极高的性能，速度和expdp/impdp相当。可用于逻辑复制软件数据初始化同步、测试环境数据导入、Oracle跨平台、版本数据迁移等。

以下示例把ANDY用户下的表t_big_table从Linux ORACLE 10g导出，然后导入到Windows ORACLE 12c：

1

osync.ini文件中配置连接字符串

conf/osync.ini
#source connect str
source=andy/andy@192.168.1.100:1521/db10205

#target connect str
target=andy/andy@192.168.1.200:1521/db11203
2

table.list文件中配置要导出、导入的表

conf/table.list
# <owner.table>   <owner.table>
andy.t_big_table andy.t_big_table
3

从Linux ORACLE 10g导入到Windows ORACLE 12c

OSYNC> init sync
OSYNC> start sync

验证导出表、并置初始复制状态为未复制。

终端输出
DB information:
  --------------------------------------------------------------------------------------------------
  |             |Machine             |DB                  |Instance            |Version             |
  --------------------------------------------------------------------------------------------------
  |From(Source) |shareplex           |DB10205             |db10205             |10.2.0.5.0          |
  --------------------------------------------------------------------------------------------------
  |  To(Target) |ANDY-PC             |TEST121             |test121             |12.1.0.1.0          |
  ------------------- ------------------------------------------------------------------------------
Are you sure to start sync? (N) y
Starting sync...
4

导入完成

可以看到，800万行，700MB（纯数据）的表，通过百兆网络带宽传输，在2分钟之内便完成导出、导入。

OSYNC> status
终端输出
Sync Table Statistics (Total: 1, Init: 0, Exported: 0, Imported: 1, Error: 0)
Sync Threads (Table synced 1, syncing 0, error 0, remain 0)

  Thread# 0: (Table synced 0, error 0, elapsed 0.00 secs, db read/db write: 0.00/0.00 secs)
    Current Table:[ ], status:[Unknown] (synced: 0.00 MB 0 rows 0.00 secs)

  Thread# 1: (Table synced 0, error 0, elapsed 0.00 secs, db read/db write: 0.00/0.00 secs)
    Current Table:[ ], status:[Unknown] (synced: 0.00 MB 0 rows 0.00 secs)

  Thread# 2: (Table synced 1, error 0, elapsed 114.55 secs, db read/db write: 10.23/104.32 secs)
    Current Table:[ANDY.T_BIG_TABLE], status:[Finish] (synced: 714.49 MB 8099838 rows 114.55 secs)

  Thread# 3: (Table synced 0, error 0, elapsed 0.00 secs, db read/db write: 0.00/0.00 secs)
    Current Table:[ ], status:[Unknown] (synced: 0.00 MB 0 rows 0.00 secs)

  Thread# 4: (Table synced 0, error 0, elapsed 0.00 secs, db read/db write: 0.00/0.00 secs)
    Current Table:[ ], status:[Unknown] (synced: 0.00 MB 0 rows 0.00 secs)