在这之前有大量的warning指明undo表空间无法扩展。
这是典型的因undo表空间满,导致数据写到dsc文件中。
解决方法:
1.扩展undo表空间
2.将dsc文件重命名,并重新touch一个想用的discard文件名。
3.重启repsc进程
关于discard文件的说明:
Use a discard file to capture information about Oracle GoldenGate operations that failed. This information can help you to resolve data errors, such as those that involve invalid
column mapping.
The discard file reports such information as:
● The database error message
● The sequence number of the data source or trail file
● The relative byte address of the record in the data source or trail file
● The details of the discarded operation, such as column values of a DML statement or
the text of a DDL statement.
比较奇怪的是,是不是只有undo满的情况下(用户表空间满)会写入discard文件?在OGG 11.1版本中,当用户表空间写满的时候,直接报错进程abend中断,而不会先报discard满。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764468/viewspace-1081293/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764468/viewspace-1081293/