Oracle Database Discussions

As you can see below, I'm trying to add additional members to my existing groups. I successfully added a member to each group. However, when I queried v$logfile, it shows the new members as being INVALID which I think means the file is not accessible. So, I looked in the OS directory and Oracle did in fact create the new members listed below.

I don't know how to remedy this situation. Any suggestions?

thanks,

Jim

SQL> alter database add logfile member
2 'E:\ORACLE\ORADATA\HBLAD\REDO01b.LOG' to group 1;

Database altered.

SQL> alter database add logfile member
2 'D:\ORACLE\ORADATA\HBLAD\REDO02b.LOG' to group 2;

Database altered.

SQL> alter database add logfile member
2 'D:\ORACLE\ORADATA\HBLAD\REDO03b.LOG' to group 3

Database altered.
-----------------------------------------------------

select * from v$logfile
/

GROUP# STATUS
---------- -------
MEMBER
----------------------------------------------------------------------------------------------------
1
D:\ORACLE\ORADATA\HBLAD\REDO01.LOG

2
E:\ORACLE\ORADATA\HBLAD\REDO02.LOG

3
E:\ORACLE\ORADATA\HBLAD\REDO03.LOG

1 INVALID
E:\ORACLE\ORADATA\HBLAD\REDO01B.LOG

2 INVALID
D:\ORACLE\ORADATA\HBLAD\REDO02B.LOG

3 INVALID
D:\ORACLE\ORADATA\HBLAD\REDO03B.LOG


6 rows selected.