Checkpoint table有兩種類型:主表和輔助表。主表根據使用者定義名稱來來建立,輔助表會自動建立。輔助表就是transaction table。名稱是checkpoint table名上加_LOX。
SQL> conn ogg/ogg Connected. SQL> SQL> select table_name from user_tables; TABLE_NAME ------------------------------ CKKPOINT_LOX CKKPOINT SQL> |
Checkpoint table配置方法:
(1):在./GLOBALS檔案裡添加checkpoint 表名
GGSCI(suys1) 1> view param ./GLOBALS ggschema ogg checkpointtableogg.checkpointtab GGSCI (suys1) 2> |
(2):連上DB,建立checkpoint表
GGSCI(suys1) 85> dblogin userid ogg, password ogg Successfullylogged into database. GGSCI(suys1) 86> add checkpointtable ogg. checkpointtab Successfully created checkpoint table ogg.checkpointtab. |
--生成這個檢查點記錄表
(3):驗證
conn ggs/ SQL> select * from checkpoint; GROUP_NA GROUP_KEY SEQNO RBA AUDIT_TS CREATE_TS LAST_UPDATE_ CURRENT_DIR -------- ---------- ------ ----------------------------------- ------------ ------------ -------------- REP1 3987940558 12 1564 2011-11-17 17:21:55.471376 17-NOV-11 17-NOV-11 /u01/ggate |