ORA-00313: open failed for members of log group 3 of thread 1
hi all,
i got after reboot the system the following message
SQL> startup
ORACLE instance started.
Total System Global Area 2.6206E+10 bytes
Fixed Size 2131496 bytes
Variable Size 2181040600 bytes
Database Buffers 2.4008E+10 bytes
Redo Buffers 14643200 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/PLF/origlogA/log_g11m1.dbf'
ORA-00312: online log 1 thread 1: '/oracle/PLF/mirrlogA/log_g11m2.dbf'
first i do these
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/oracle/PLF/origlogB/log_g14m1.dbf
/oracle/PLF/mirrlogB/log_g14m2.dbf
/oracle/PLF/origlogA/log_g13m1.dbf
/oracle/PLF/mirrlogA/log_g13m2.dbf
/oracle/PLF/origlogB/log_g12m1.dbf
/oracle/PLF/mirrlogB/log_g12m2.dbf
/oracle/PLF/origlogA/log_g11m1.dbf
/oracle/PLF/mirrlogA/log_g11m2.dbf
SQL> select GROUP# ,status from v$log;
GROUP# STATUS
---------- ----------------
1 INACTIVE
4 INACTIVE
3 CURRENT
2 INACTIVE
then
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE GROUP 1 ('/oracle/PLF/origlogA/log_g11m1.dbf','/oracle/PLF/mirrlogA/log_g11m2.dbf')size 200M;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oracle/PLF/origlogB/log_g12m1.dbf'
ORA-00312: online log 2 thread 1: '/oracle/PLF/mirrlogB/log_g12m2.dbf'
SQL> select GROUP# ,status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
4 INACTIVE
3 CURRENT
2 INACTIVE
after that i do
SQL> alter database drop logfile group 2;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE GROUP 2('/oracle/PLF/origlogB/log_g12m1.dbf','/oracle/PLF/mirrlogB/log_g12m2.dbf')size 200M;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/PLF/origlogA/log_g13m1.dbf'
ORA-00312: online log 3 thread 1: '/oracle/PLF/mirrlogA/log_g13m2.dbf'
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open
now i have this
SQL> select GROUP# ,status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
4 INACTIVE
3 CURRENT
2 UNUSED
PLEASE HELPME to solve this, its the production system