Sample Header Ad - 728x90

Encountering "Snapshot too old" error during execution of expdp command

0 votes
3 answers
41035 views
As am facing an issue while performing expdp command in my production db.(Oracle 11g in windows enviornment) >cmd> expdp 'sys/123@PROD as sysdba' DUMPFILE=BACKUP_02082017_BACKUP.dmp LOGFILE=BakupLog_02082017_BACKUP.log SCHEMAS=A1,B2,C3,D4.. exclude=statistics consistent=y It was taking more than 1 day to export the database sized 7GB. But my issue is that the exporting have error and shows error message >ORA-31693: Table data object "owner"."PASSWORD_HISTORY" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_255734752$" too small As i set my retention policy to 16500 from default 900. Even though, same error was occurring. As i am planning to increase the retention policy up to 10 hrs ie, 36000. Is it viable? I am confused that do my undo table space is capable for this or not? Providing some more details: > show parameter undo_%; NAME TYPE VALUE -------------------------------------------------- ----------- -------- undo_management string AUTO undo_retention integer 16500 undo_tablespace string UNDOTBS1 > select file_name,tablespace_name,trunc(bytes/1024/1024) mb, trunc(maxbytes/1024/1024) mm FROM dba_data_files where tablespace_name = 'UNDOTBS1'; FILE_NAME TABLESPACE_NAME MB MM -------------------------------------------------------------------- C:\APP\ADMIN\ORADATA\PROD\UNDOTBS01.DBF UNDOTBS1 5630 32767 >Size of undo with current undo_retention : Actual Undo size[MBytes]:5630 UNDO retention[Sec]:16500 Needed Undo Size[MBytes]:909.433359 I am stuck with this issue. Anyone please advice how i deal with this error? Thanks in advance.
Asked by SHS (152 rep)
Feb 8, 2017, 01:09 PM
Last activity: Dec 10, 2024, 03:35 PM