hi,
I am currently facing an issue on an Oracle RAC 12c (12.1.2.0) configuration, (2 nodes), when I start a batch including, in the first step, an export database via "expdp".
Whatever the node i use to launch this bactch, it failed with the same error, but not all the time . sometimes it works. When it works, it takes a bit less than two hours to generate the expdp dump.
The undo_retention parameter value is 18000 ==> 5 hours
the undo TBS size : 45Gb, but its size can increase up to 64Gb.
I have some LOB in different tables .
When it fails, I always experience the same error : Snapshot too old; undo_retention error.
Any clue// suggestions regarding this issue ?
could it be a problem with disk IO for example?
thanks for your help.
rgds
hubert