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.

Leave a Reply