Delphix Products

Expand all | Collapse all

Getting Snapshot too old error while masking the data

Jump to Best Answer
  • 1.  Getting Snapshot too old error while masking the data

    Posted 02-16-2016 07:00:00 PM
    Two of the masking jobs has been failed due to snap shot too old error. Is there any way to avoid this error?
    #Masking


  • 2.  RE: Getting Snapshot too old error while masking the data
    Best Answer

    Posted 02-16-2016 07:55:00 PM
    The ORA-01555 ("snapshot too old") error is always fun to diagnose and prevent.

    It is always a bad sign when a particular issue warrants its own "Master Note" page in the MyOracleSupport portal, as this topic does.  But that just let's you know how many different causes can lead to this error.

    Just off-the-cuff, what is the setting of the UNDO_RETENTION parameter in this database?  The default is 900 seconds (15 mins) and that is usually too low, so you might consider setting that value to match or exceed the expected duration of the masking job(s).  For example, if your masking jobs take 2-4 hours, you might want to consider ensuring that UNDO_RETENTION has a value of 14,400 seconds or greater.  The good news is that UNDO_RETENTION is dynamically changeable with very low risk of unexpected side-effects to the Oracle database.

    The good news is that setting this parameter and sizing the UNDO tablespace large enough is usually all that is necessary.  The bad old days of fiddling with rollback segments are long in the past.

    Please let me know if this helps?

    Thanks!

    -Tim


  • 3.  RE: Getting Snapshot too old error while masking the data

    Posted 06-20-2016 06:45:00 PM

    Hello Tim,


    May you happen to know where I can view error logs. I cannot locate the folder where the XML output is located. I



  • 4.  RE: Getting Snapshot too old error while masking the data

    Posted 06-20-2016 07:08:00 PM
    The location of the "alert.log" file is dependent on the Oracle initialization variable BACKGROUND_DUMP_DEST.  From version to version of Oracle, the default location can vary, but usually it is located within a sub-directory of the "$ORACLE_BASE" directory.  If you can't display the BACKGROUND_DUMP_DEST value, then you can use the UNIX/Linux "find" command to find it using something like "find ${ORACLE_BASE} -name alert${ORACLE_SID}.log -print".

    Hope this helps!