ORA-00362: member is required to form a valid logfile in group 1

SQL> SELECT GROUP#,STATUS,TYPE FROM V$LOGFILE
  2  ;

    GROUP# STATUS  TYPE
---------- ------- -------
         3 STALE   ONLINE
         3 STALE   ONLINE
         2 STALE   ONLINE
         2 STALE   ONLINE
         1 STALE   ONLINE
         1 INVALID ONLINE
         4 STALE   ONLINE
         4 STALE   ONLINE
         3 INVALID ONLINE

9 rows selected.

SQL> SELECT GROUP#,STATUS,TYPE FROM V$LOGFILE WHERE STATUS='INVALIDE'
  2  ;

no rows selected

SQL> SELECT GROUP#,STATUS,TYPE FROM V$LOGFILE WHERE STATUS='INVALID'
  2  ;

    GROUP# STATUS  TYPE
---------- ------- -------
         1 INVALID ONLINE
         3 INVALID ONLINE

SQL> SELECT GROUP#,STATUS,MEMBER FROM V$LOGFILE WHERE STATUS='INVALID'
  2  ;

    GROUP# STATUS
---------- -------
MEMBER
---------------------------------------------------------------------------

         1 INVALID
F:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DBF

         3 INVALID
G:\ORACLE\SOL\ORIGLOGA\LOG_G11M5


SQL> SELECT GROUP#,STATUS,MEMBER FROM V$LOGFILE WHERE STATUS='INVALID'
  2  ;

    GROUP# STATUS
---------- -------
MEMBER
---------------------------------------------------------------------------

         1 INVALID
F:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DBF

         3 INVALID
G:\ORACLE\SOL\ORIGLOGA\LOG_G11M5


SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open





SQL> alter database drop LOGFILE MEMBER'F:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DB
alter database drop LOGFILE MEMBER'F:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DBF'
*
ERROR at line 1:
ORA-00362: member is required to form a valid logfile in group 1

Solution  (for my refrence)

Create the control file  using trace file (alter database backup controllfile to trace;)

remove the invalid control file and group from the trace file.

and re create the control on  nomount mode.

SQL> @C:\ctrl.sql
control file created.

then execute the 

SQL> recover database;
media recovered successfully
SQL> Alter database open;
database opened;




select group#,member from v$logfile where status='INVALID';

select Group#,status,type from v$logfile;

2EETW000 sap_dext called with msgnr "32":2EETW000 fcode: NT_RDTDESCR

BR1001I BRSPACE 7.20 (30)
BR1002I Start of BRSPACE processing: seoagxvc.dfa 2014-06-07 10.52.00
BR0484I BRSPACE log file: C:\oracle\SOL\sapreorg\seoagxvc.dfa
BR0280I BRSPACE time stamp: 2014-06-07 10.52.01
BR0301W SQL error -376 at location BrDbaSynCheck-1, SQL statement:
'SELECT COUNT(*) FROM SAP_SDBAH WHERE BEG = '00000000000000''
ORA-00376: file 6 cannot be read at this time
ORA-01110: data file 6: 'F:\ORACLE\SOL\SAPDATA2\SR3_3\SR3.DATA3'
BR0280I BRSPACE time stamp: 2014-06-07 10.52.01
BR0301E SQL error -376 at location BrLicCheck-12, SQL statement:
'SELECT MAX(SYSTEMNAME), MAX(SYSID) FROM SAP_MLICHECK WHERE EXPIRATION_DATE = (SELECT MAX(EXPIRATION_DATE) FROM SAP_MLICHECK)'
ORA-00376: file 10 cannot be read at this time
ORA-01110: data file 10: 'F:\ORACLE\SOL\SAPDATA2\SR3_7\SR3.DATA7'
BR0700E Fatal errors occurred - terminating processing...
BR0280I BRSPACE time stamp: 2014-06-07 10.52.01
BR0301W SQL error -376 at location BrsDbLogOpen-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20140607105200', 'dfa', 'SOL', ' ', '9999', ' ', 'seoagxvc', '7.20 (30)')'
ORA-00376: file 8 cannot be read at this time
ORA-01110: data file 8: 'F:\ORACLE\SOL\SAPDATA2\SR3_5\SR3.DATA5'
BR0324W Insertion of database log header failed
BR1008I End of BRSPACE processing: seoagxvc.dfa 2014-06-07 10.52.01
BR0280I BRSPACE time stamp: 2014-06-07 10.52.01
BR1007I BRSPACE terminated with errors


 Symptom
Termination in phase SHADOW_IMPORT_ALL with the following error text:
2EETW000 sap_dext called with msgnr "32":
2EETW000 db call info
2EETW000 function:   db_ntab
2EETW000 fcode:      NT_RDTDESCR
Additional key words
Cause and prerequisites
This is a program error.
Solution
A new R3trans is now available on the sapserv machines to eliminate the error.
The new R3trans is registered with the date '11.OCT.01' or earlier. Note 19466 contains instructions on downloading files from the sapserv machines.
- See more at: http://www.stechno.net/sap-notes.html?view=sapnote&id=442193#sthash.U66Xfz5L.dpuf

401717Additional info on upgrading to SAP Web AS 6.10 (Basis)19466Downloading SAP kernel patches - See more at: http://www.stechno.net/sap-notes.html?view=sapnote&id=442193#sthash.U66Xfz5L.dpuf