回滚记录版本太旧
描述:
回滚记录版本太旧,无法获取用户记录。
处理方式:
方法一:更改dm.ini中UNDO_RETENTION,适当放大该参数。
方法二:更改dm.ini中ENABLE_IGNORE_PURGE_REC,忽略该报错。
[dmdba@DMMPP-01 MPP1_01]$ cat dm.ini |grep UNDO_RETENTION
UNDO_RETENTION = 90.000 #Maximum retention time in seconds for undo pages since relative transaction is committed
[dmdba@DMMPP-01 MPP1_01]$ cat dm.ini |grep ENABLE_IGNORE_PURGE_REC
ENABLE_IGNORE_PURGE_REC = 0 #Whether to ignore purged records when returning -7120