ORA-00305: log 1 of thread 1 inconsistent; belongs to another database

log_file_name_convert fail ;)

ORA-00305 DUPLICATE| RMAN ORA-00305 | REDO ORA-00305

ORA-00305: log 1 of thread 1 inconsistent; belongs to another database

Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc:
ORA-00305: dziennik 6 wątku 1 jest niezgodny; należy do innej bazy danych
ORA-00312: dziennik online 6 wątek 1: '/oradb1/scomm/redo06.log'
Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc:
ORA-00305: dziennik 7 wątku 1 jest niezgodny; należy do innej bazy danych
ORA-00312: dziennik online 7 wątek 1: '/oradb1/scomm/redo07.log'
Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc:
ORA-00316: dziennik 8 wątku 1, typ 0 w nagłówku nie jest plikiem dziennika
ORA-00312: dziennik online 8 wątek 1: '/oradb1/scomm/redo08.log'

SQL> select GROUP#, status,MEMBERS ,archived from v$log ;

GROUP# STATUS MEMBERS ARC
---------- ---------------- ---------- ---
1 CURRENT 1 NO
2 ACTIVE 1 NO
3 ACTIVE 1 NO
8 INACTIVE 1 NO
5 ACTIVE 1 NO
6 ACTIVE 1 NO
7 ACTIVE 1 NO
4 ACTIVE 1 NO

8 rows selected.

SQL> desc v$log ;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
BLOCKSIZE NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
NEXT_CHANGE# NUMBER
NEXT_TIME DATE

SQL> select * from v$logfile ;

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 ONLINE
/oradb1/scomm/redo03.log
NO

2 ONLINE
/oradb1/scomm/redo02.log
NO

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---

1 ONLINE
/oradb1/scomm/redo01.log
NO

4 ONLINE
/oradb1/scomm/redo04.log

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
NO

5 ONLINE
/oradb1/scomm/redo05.log
NO

6 ONLINE

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
/oradb1/scomm/redo06.log
NO

7 ONLINE
/oradb1/scomm/redo07.log
NO

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
8 ONLINE
/oradb1/scomm/redo08.log
NO

8 rows selected.

SQL> alter system checkpoint ;
alter system checkpoint
*
ERROR at line 1:
ORA-01109: baza danych nie jest otwarta

SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ID procesu: 2097352
ID sesji: 130, numer seryjny: 5

SQL> startup mount ;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
commdb_oracle:/home/oracle# sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 4 17:16:25 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount ;
ORACLE instance started.

Total System Global Area 4710043648 bytes
Fixed Size 2229384 bytes
Variable Size 1761610616 bytes
Database Buffers 2936012800 bytes
Redo Buffers 10190848 bytes
Database mounted.
SQL> select GROUP#, status,MEMBERS ,archived from v$log ;

GROUP# STATUS MEMBERS ARC
---------- ---------------- ---------- ---
1 CURRENT 1 NO
2 INACTIVE 1 NO
3 INACTIVE 1 NO
8 INACTIVE 1 NO
5 INACTIVE 1 NO
6 INACTIVE 1 NO
7 INACTIVE 1 NO
4 INACTIVE 1 NO

8 rows selected.

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 8 ;

Database altered.

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 7;

Database altered.

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 6;

Database altered.

SQL> ALTER DATABASE OPEN ;

Database altered.

SQL>