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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01342：由于无法分段检查点数据，LogMiner无法恢复会话,
.原因： Logmnr无法恢复会话，因为没有足够的SGA内存可用于读取检查点数据。Logminer定期检查点数据，以实现更快的崩溃恢复。,
.操作：为给定的LogMiner会话指定一个更大的max_sga，然后重试。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题