ORA-00346: log member marked as STALE and closed ORACLE 报错 故障修复 远程处理
文档解释
ORA-00346: log member marked as STALE and closed
Cause: A log file member was no longer complete.
Action: Correct the underlying problem by referring to the other error messages found with this one.
ORA-00346: log member marked as STALE and closed
该错误指示当剌日志文件 尝试关闭时，具有更改的重做日志。
官方解释
This error is thrown when ORACLE attempts to close a redo log with changes.
常见案例
ORA-00346 错误通常出现在实例重启时。这意味着一些重做日志文件在实例崩溃之前没有及时被清理，现在已经标记为STALE。
正常处理方法及步骤
1.检查实例是否已经启动，查看V$LOGMNR_CONTENTS视图中的STALE标志，并确认哪些文件没有完成CLEAR操作。
2.停止实例，并以管理员身份打开档案模式，以手动清理STALE重做日志。
3.使用Oracle工具“aleter database clear logfile ”清除STALE重做日志。
4.启动实例，重新检验V$LOGMNR_CONTENTS视图，确保STALE标志已更新为CLEAR。
