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 <sukuora_at_yahoo.com> 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: sukuora_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: wbpass_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri May 17 2002 - 08:28:26 CDT