IOType : 15 (x0f) OrigNode : 255 (xff) TransInd : . (x00) FormatType : R (x52) SyskeyLen : 0 (x00) Incomplete : . (x00) AuditRBA : 950 AuditPos : 915048500 Continued : N (x00) RecCount : 1 (x01)
2013/04/24 20:33:00.010.627 FieldComp Len 91 RBA 355778 Name: HX_FP.FP_PZHDXX
After Image: Partition 4 G b
0000 0022 0000 4232 3742 3133 35354146 3646 3430 | ...\ 3945 3839 3145 3142 4238 4144 36383837 4438 000c | 9E891E1BB8AD6887D8.. 000d 0000 3135 3030 3931 3030 30303000 1000 1500 | ....15009100000..... 0032 3031 332d 3034 2d32 343a 32303a33 333a 3030 | .2013-04-24:20:33:00 0011 0007 0000 3135 3030 39 | ......15009 Column 0 (x0000), Len 34 (x0022) Column 12 (x000c), Len 13 (x000d) Column 16 (x0010), Len 21 (x0015) Column 17 (x0011), Len 7 (x0007)
执行的 update 语句为：
UPDATE HX_FP.FP_PZHDXX SET SWJG_DM = ‘15009100000’,XGRQ= ‘2013-04-24:20:33:00’,SJGSDQ= ‘15009’ WHERE HDQCUUID = ‘B27B1355AF6F409E891E1BB8AD6887D8’
其中SJGSDQ 正是HX_FP.FP_PZHDXX 表的分区键。
针对这种修改分区表分区键的操作导致的 replicat 进程挂起，metalink 上给出的建议为在应用设计时尽量避免这种操作，启用该表的 row movement便可临时解决这一问题。 SQL> alter table HX_FP.FP_PZHDXX enablerow movement; Table altered.
GGSCI (bjsczjdbzsj01) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING EZJTS_TS 00:00:00 00:00:02 EXTRACT RUNNING PZJTS_TS 00:00:00 00:00:03 REPLICAT ABENDED RFP_ZJ3 00:00:00 12:21:37 REPLICAT RUNNING RFX_ZJ3 00:00:00 00:00:07 REPLICAT RUNNING RGZ_ZJ5 00:00:00 00:00:02 REPLICAT RUNNING RNSTS_ZJ 00:00:00 00:00:03 REPLICAT RUNNING RNS_ZJ2 00:00:00 00:00:01 REPLICAT RUNNING RSB_ZJ4 00:00:00 00:00:04 GGSCI (bjsczjdbzsj01) 3> start RFP_ZJ3 Sending START request to MANAGER ... REPLICAT RFP_ZJ3 starting GGSCI (bjsczjdbzsj01) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT STOPPED
EXTRACT RUNNING EZJTS_TS 00:00:00 00:00:05 EXTRACT RUNNING PZJTS_TS 00:00:00 00:00:06 REPLICAT RUNNING RFP_ZJ3 00:00:00 00:00:00 REPLICAT RUNNING RFX_ZJ3 00:00:00 00:00:00 REPLICAT RUNNING RGZ_ZJ5 00:00:00 00:00:03 REPLICAT RUNNING RNSTS_ZJ 00:00:00 00:00:06 REPLICAT RUNNING RNS_ZJ2 00:00:00 00:00:09