SQLDBA> SELECT * FROM V$LOGFILE;
GROUP# STATUS MEMBER
---------- ------- ------------------------------
1 STALE /oracle/7.3.4/dbs/log1P734.dbf
2 /oracle/7.3.4/dbs/log2P734.dbf
3 /oracle/7.3.4/dbs/log3P734.dbf
解决方法总结:
1,千万不要在发生stale的情况下强制关闭数据库。
2,多查询几次日志状态,看stale状态是否会消失。
3,如果再数次查询无效后,可以切换日志。
4,切换日志过户,可以执行强制检查点操作。
5,不断切换日志,强制检查点,查询,直至stale状态消失。
WARNING:
DO NOT ISSUE A SHUTDOWN ABORT BEFORE GOING THROUGH STEPS1 AND 2 BELOW.
Solution Description:
=====================
In general, the stale status of a redo log member should not be acause for
great concern, unless you obser