问题描述:数据库导出数据日志报错
操作系统版本:RHEL AS4 U4 64bit
数据库版本:Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit
错误代号:ORA-01555 ORA-22924
查看导出数据命令
$ cat /oradata/info/backup/scripts/exp_couser
exp user/passwd buffer=1048576 compress=n owner=couser statistics=none compress=n consistent=y file=/oradata/info/backup/exp_couser_`date +%Y%m%d`.dmp log=/oradata/info/backup/exp_log_`date +%Y%m%d_%H%M%S`.log
查看exp导出数据日志
$ cat /oradata/info/backup/exp_log_20080218_010101.log
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user COUSER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user COUSER
About to export COUSER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export COUSER's tables via Conventional Path ...
. . exporting tableFSM_COLTREE2XXFL84 rows exported
. . exporting tableFSM_RIGHT_ARTICLE
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment numberwith name "" too small
ORA-22924: snapshot too old
. . exporting tableFSM_RIGHT_COLTREE369 rows exported
. . exporting tableFSM_RIGHT_DELEY227 rows exported
. . exporting tableFSM_RIGHT_GROUP3 rows exported
. . exporting tableFSM_RIGHT_USER8 rows exported
. . exporting tableFSM_SYSTEM_ADMIN1 rows exported
. . exporting tableLOG_ARTICLE_PUBLISH5688437 rows exported
. . exporting tableTBL_FSM_PRODUCTINFO948 rows exported
. . exporting tableTBL_FSM_PRODUCTS206 rows exported
. . exporting tableTBL_FSM_PRODUCT_TYPE7 rows exported
. . exporting tableTBL_FSM_SCREEN_TYPE12 rows exported
. . exporting tableTBL_FSM_STYLE_INFO7278 rows exported
. . exporting tableTBL_FSM_STYLE_POSITION159 rows exported
. . exporting tableTBL_FSM_USER2 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
.