24 积分	0 好友	2 主题

发消息

[备份恢复] 关于DBLINK+OR1555

1^#

发表于 2013-4-3 10:23:27 | 查看: 5757| 回复: 6

数据源数据库物理DG
本地数据库测试库（无任何业务）

本地数据库有一个很简单的存储过程，就是凌晨通过DBLINK去数据源数据库抓取昨天数据

但是每天上班查看抓取都失败，手动执行任何一条抓取数据语句会报出ORA1555

SQL> INSERT INTO VC_VIRTUAL_CARD_INFO SELECT * FROM VC_VIRTUAL_CARD_INFO@dblink_dataextraction;
INSERT INTO VC_VIRTUAL_CARD_INFO SELECT * FROM VC_VIRTUAL_CARD_INFO@dblink_dataextraction
*
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 10 with name
"_SYSSMU10_3271578125$" too small
ORA-02063: preceding line from DBLINK_DATAEXTRACTION

在本地数据库手动执行ROLLBACK后不会报错，执行存储过程也可以顺利完成数据抓取，但第二天凌晨自动运行又会失败，如此循环

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-4-3 10:26:37

远程端的alert.log打包压缩上传

回复只看该作者道具举报

zmyzmy726

3^#

发表于 2013-4-3 10:34:08

Maclean Liu(刘相兵发表于 2013-4-3 10:26
远程端的alert.log打包压缩上传

已经上传

alert.txt

5.76 KB, 下载次数: 1015

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-4-3 10:35:08

ORA-01555 caused by SQL statement below (SQL ID: 8pnn858s1cdq1, Query Duration=0 sec, SCN: 0x0000.b86a0048):
SELECT /*+ OPAQUE_TRANSFORM */ "LOG_SQ","INT_USER_ID","INT_CARD_NO","CUP_CARD_NO","PAY_PWD","DAY_ERR_NUM","SUM_ERR_NUM","PWD_QUESTION","PWD_ANSWER","LAST_BAL","TODAY_BAL","CUR_BAL","LOC_BAL","TODAY_DRAW_AMT","SUM_DRAW_AMT","TODAY_HUI_AMT","SUM_HUI_AMT","TODAY_TRANS_AMT","SUM_TRANS_AMT","TODAY_PAY_AMT","SUM_PAY_AMT","CARD_STAT","OPEN_TYPE","OPEN_DATE","CARD_INTEGRAL","CARD_DESC","DB_MAC","MISC_TX","LAST_UPD_OPR_ID","GLOBAL_TXN_ID","LAST_UPD_TS","TICKET_AMT","LOCK_TICKET_AMT","CRITICAL_POINT","VERSION","TOTAL_INVOICE_AMT","TOTAL_REFUNDFEE_AMT","CARD_TYPE","BT_STAT","SPV_SIGN_TYPE" FROM "VC_VIRTUAL_CARD_INFO" "VC_VIRTUAL_CARD_INFO"
Wed Apr 03 10:28:21 2013

Query Duration=0, 你是截的alert.log 看不到 db版本

回复只看该作者道具举报