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