10 Replies Latest reply: Nov 30, 2012 3:25 AM by Osama_Mustafa RSS

    ORA-01206: file is not part of this database

    679081
      I have a peculiar case, and asking if anybody has dealt with something similar. I have 2 databases that were cloned from the same Database in 11.2.0.3 , the source DB has a tablespace that is of no importance,I just want to drop it in the cloned databases, but when I went to drop it, I got the following error:
      UCV31 >select DBID,open_mode from v$database;
      
            DBID OPEN_MODE
      ---------- ------------------------------------------------------------
      2211912429 READ WRITE
      
      UCV31 >select file_name from dba_data_files where TABLESPACE_NAME='TEST1';
      
      FILE_NAME
      --------------------------------------------------------------------------------
      +GBS_FRA/test/test01.dbf
      
      
      UCV31 >select STATUS from dba_tablespaces where TABLESPACE_NAME='TEST1';
      
      STATUS
      ---------------------------
      ONLINE
      
      UCV31 >drop tablespace TEST1;
      drop tablespace TEST1
      *
      ERROR at line 1:
      ORA-01122: database file 148 failed verification check
      ORA-01110: data file 148: '+GBS_FRA/test/test01.dbf'
      ORA-01206: file is not part of this database - wrong database id
      So what I did, was do dump of the headers and indeed , the header is showing that the datafile belongs to the second database
       V10 STYLE FILE HEADER:
              Compatibility Vsn = 186646528=0xb200000
              Db ID=4005607769=0xeec0b959, Db Name='UCQ1'
      Now if I go to the second Database I see that this tablespace is also online
      UCQ11 >select STATUS from dba_tablespaces where TABLESPACE_NAME='TEST1';
      
      STATUS
      ---------------------------
      ONLINE
      
      UCQ11 >select file_name from dba_data_files where TABLESPACE_NAME='TEST1';
      
      FILE_NAME
      --------------------------------------------------------------------------------
      +GBS_FRA/test/test01.dbf
      So before I proceed, has anybody seen something similar in where 2 databases where using the same datafile and how did you proceed?

      I'm thinking of dropping the tablespace in UCQ1 and then in UCV3, though UCV3 might already be a corrupted database, but it's not a problem I can restore this database from the source, I just want to see if anybody has seen this before and how have you solved it

      Environment:
      DB:11.2.0.3
      Grid:11.2.0.3
      OS: Linux 2.6.18-238.el5 x86_64