因此,我开始使用AWS数据迁移服务将内部部署的Oracle数据库迁移到AWS RDS Postgres。到目前为止一切顺利,绝大多数表都得到了迁移(约2000个),但有两个表失败。我启用了所有可用的日志记录和调试选项,但无法获得更多:
18:56:12
2019-05-06T18:56:12:558678 [SOURCE_UNLOAD ]D: Table schema 'my_schema.SRV_LOG_TABLE' is completed (oracle_endpoint_table.c:1880)
18:56:12
2019-05-06T18:56:12:564726 [SOURCE_UNLOAD ]D: Cannot refresh source table (1) metadata [1021803] (endpointshell.c:3138)
18:56:12
2019-05-06T18:56:12:564726 [SOURCE_UNLOAD ]E: Cannot refresh source table (1) metadata [1021803] (endpointshell.c:3138)
18:56:12
2019-05-06T18:56:12:584501 [SOURCE_UNLOAD ]D: Start unload loop (oracle_endpoint_unload.c:346)
18:56:12
2019-05-06T18:56:12:584507 [TASK_MANAGER ]W: Table 'my_schema'.'SRV_LOG_TABLE' (subtask 1 thread 0) is suspended (replicationtask.c:2356)
18:56:12
2019-05-06T18:56:12:584540 [SOURCE_UNLOAD ]D: Unable to get table name for id '0' [1021802] (oracle_endpoint_unload.c:351)
18:56:12
2019-05-06T18:56:12:589667 [TASK_MANAGER ]D: Subtask #1 is going down (replicationtask_util.c:536)
我不太清楚发生了什么,也无法确定这些表有什么“特殊”之处(其他表生成的日志完全相同)。有人遇到过类似的情况并找到了解决方案吗?
PS:虽然我确实启用了内容日志表,但那里什么都没有创建...
1条答案
按热度按时间1bqhqjot1#
checkout ....似乎自动运行了DDL,并打乱了定义https://community.qlik.com/t5/Official-Support-Articles/SOURCE-CAPTURE-E-Unable-to-get-table-definition-for-table-0/ta-p/1809603