Re: Redo Log Status
From: Thomas Pall <tpall_at_realtime.net>
Date: 1998/11/29
Message-ID: <73s992$8k0_at_jake.bga.com>#1/1
Date: 1998/11/29
Message-ID: <73s992$8k0_at_jake.bga.com>#1/1
Stale means that Oracle has received at least on file error when writing to the file. Since redo logs should be multiplexed, this should not cause a problem. As soon as the stale redo log again becomes part of the active group, this will be fixed. However if a redo log receives 4 i/o errors, Oracle will mark it as invalid and will not try to write to it again.
It will have to be dropped and recreated.
It get this from page 50 of Oracle Backup & Recovery Handbook 7.3 edition, by Rama Velpumi, Oracle Press.
-- Tom Pall, contract Oracle DBAReceived on Sun Nov 29 1998 - 00:00:00 CET