'stale' redo log files
Is the 'STALE' status of the redo log files in V$LOGFILE critical?
This status means the logfile contains incomplete redo info. This status prevents the logfile from being dropped without being archived first. You should not worry about this status unless it happens repeatedly. Becuase "stale" does not mean "invalid". When this redo group becomes current, this state will automatically become valid.
Sometimes when you restart your db or newly created log group, v$logfile will show 'STALE' status. One easy way to check is issuing:
alter system switch logfile;
then check v$logfile again.
The 'STALE' status' should disappear.
thank you all for your replies
Click Here to Expand Forum to Full Width