OSYNC产品特性
ORACLE数据库间高速的导出、导入
直接路径导出、导入的优点如下：
- 直接路径操作的性能极高，导出/导入速度和expdp/impdp相当。
- 导出、导入时跳过了SQL层，避免了对SGA造成影响。
- Nologging方式加载，避免了导入时生成大量的UNDO/REDO。
可以看到，以下导出、导入800万行、700MB（纯数据）的表，仅花费23秒左右便完成导出、导入。
1
表结构
SQL
SQL> desc andy2.t_big_table Name Null? Type ----------------------------------------------------- -------- ------------------------------------ OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(128) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) NAMESPACE NUMBER EDITION_NAME VARCHAR2(30)
SQL
SQL> select count(*) from andy2.t_big_table; COUNT(*) ---------- 8099838
2
启动同步
terminal
OSYNC> start sync DB information: -------------------------------------------------------------------------------------------------- | |Machine |DB |Instance |Version | -------------------------------------------------------------------------------------------------- |From(Source) |shareplex |DB10205 |db10205 |10.2.0.5.0 | -------------------------------------------------------------------------------------------------- | To(Target) |shareplex |DB11203 |db11203 |11.2.0.3.0 | ------------------- ------------------------------------------------------------------------------ Are you sure to start sync? (N) y Starting sync...
3
导入结束
terminal
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 1, error 0, elapsed 23.81 secs, db read/db write: 14.07/9.74 secs)
Current Table:[ANDY.T_BIG_TABLE], status:[Finish] (synced: 714.49 MB 8099838 rows 23.81 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 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# 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)