Oracle DBA, How To, Error, Cause and Action

ORA-01342: LogMiner can not resume session due to inability of stagingcheckpointed data

ORA-01342: LogMiner can not resume session due to inability of staging checkpointed data




Cause: Logmnr can not resume session because there is not enough SGA memory available to read in checkpointed data. Logminer periodically checkpoints data to enable faster crash recovery.




Action: Specify a bigger max_sga for the given LogMiner session and try again.