Oracle-L: Symbolic links, Raw device

From: Sukumar Kurup <sukuora_at_yahoo.com>
Date: Thu, 16 May 2002 18:08:26 -0800
Message-ID: <F001.00463183.20020516180826@fatcity.com>

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).

Received on Thu May 16 2002 - 21:08:26 CDT