I have heard of this occuring in the past on an IBM port, but do not recall the exact details. I think it had something to do with adding a link to a datafile belonging to another datbase, and that datbase was down at the time. It definitely resulted in a corrupt datbase (ugly recovery).
However, a quick test on my 9i Sun system w/raw files reveals the following error when attempting to add the second data file to the same underlying file. SQL> create tablespace x datafile '/d8100/dba/oracle/file1.dbf' size 100m; Tablespace created. SQL> alter tablespace x add datafile '/d8100/dba/oracle/file2.dbf' size 100m; alter tablespace x add datafile '/d8100/dba/oracle/file2.dbf' size 100m * ERROR at line 1: ORA-01119: error in creating database file '/d8100/dba/oracle/file2.dbf' ORA-27086: skgfglk: unable to lock file - already in use SVR4 Error: 11: Resource temporarily unavailable Additional information: 8 Bill --- Sukumar Kurup <[EMAIL PROTECTED]> wrote: > Hi, > > One of my friend is having a peculiar problem and > will > appreciate any help from this group. > > Is it possible for 2 symbolic links to point to the > same raw device and be able to create both datafiles > ? > The following is the situation, experienced by him: > > There is a tablespace having (staging_d_03.dbf) > which > is a symbolic link to a raw device > (/dev/vg02/rlvol19) > . This datatafile is a part of tablespace STAGING_D. > > By mistake, another link was created > (appusr_d27.dbf) > pointing to the same raw device. > > 17 May 7 17:01 staging_d_03.dbf -> > /dev/vg02/rlvol19 > 17 May 15 15:09 appusr_d27.dbf -> > /dev/vg02/rlvol19 > > Now, he has been able to add this (appusr_d27.dbf) > to > another tablespace (APP_USERS) WITHOUT using the > "reuse" clause . Is it possible ? > > (I do not have any raw device to test this, but > tried > creating symbolic links to the same file (on > filesystem) and was,as expected, unable to add the > existing datafile to another tablespace ) > > Further, he took the dump of the control file (alter > database backup controlfile to trace;) and it is > showing both the datafiles. > > He actually does not need the staging datafile any > more, so can he just go ahead and drop the datafile > (by recreating the STAGING_D tablespace ? What must > be > happening ? Is it possible that the file has been > overwritten/corrupt ? > > Thanks > > Sukumar Kurup > > > > > __________________________________________________ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sukumar Kurup > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
