INVALID redo log after creating a new group member
741847Mar 11 2011 — edited Mar 11 2011Hi all,
I've just followed instructions to create a new redo log file member:
alter database add logfile member '/oracle/mplex/redo/redo01b.log' to group 1;
When I query v$logfile, the status is INVALID though.
SQL> select * from v$logfile where group# = 1;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
1 ONLINE
/u01/app/oracle/oradata/redo01.log
NO
1 INVALID ONLINE
/oracle/mplex/redo/redo01b.log
NO
the oracle user owns the mplex directory and permission are fine
[oracle@redo]$ ls -ltr
total 51260
-rw-r----- 1 oracle oinstall 52429312 Mar 11 11:55 redo01b.log
Any ideas?
Thanks