Saturday, 14 January 2012

ORA-01342: LogMiner can not resume session due to inability of staging checkpointed 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.

No comments:

Post a Comment