LOGFILE STATUS ‘INVALID’ ORACLE
After adding new logfile to an existing group, the status of logfile is invalid.
kIsH@x3z6zx9<^>select * from v$logfile;
7 INVALID ONLINE
+REDOX/x3z6zx9/onlinelog/group_7.261.1102801081
NO
6 INVALID ONLINE
+REDOX/x3z6zx9/onlinelog/group_6.262.1102801085
NO
Do not panic by the invalid status. It is expected behavior, when logfile is not initialized to record changes.
Switch the logfiles for a few times
kIsH@x3z6zx9<^>alter system switch logfile;
System altered.
Elapsed: 00:00:00.04
kIsH@x3z6zx9<^>/
System altered.
Elapsed: 00:00:00.04
kIsH@x3z6zx9<^>/
System altered.
Check the logfile status and it is active.
kIsH@x3z6zx9<^>select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IS_
---
7 ONLINE
+REDOX/x3z6zx9/onlinelog/group_7.261.1102801081
NO
6 ONLINE
+REDOX/x3z6zx9/onlinelog/group_6.262.1102801085
NO
10 rows selected.