RE: Not able to find data file on server but database is working fine

From: Elliott, Patrick <patrick.elliott_at_medtronic.com>
Date: Fri, 22 Jun 2007 15:05:15 -0500
Message-ID: <302F06193D7F4D48ABC997408E786BD0022ED1D1@MSPM1BMSGM09.ent.core.medtronic.com>

If the file was deleted outside the database, then it will still be held open while the database is running. The database sees the file because it is still holding the i-node for the file. If this is what happened, then I would quickly create a new tablespace and move everything out of the one that has the hidden file. Otherwise, you will lose all of the data in the tablespace when the database goes down. The only way to recover the file will be to do a recovery from backup and apply the archive logs.

The only other situation that I can see causing this might be file permissions.

Pat

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Friday, June 22, 2007 2:18 PM
To: oracle-l_at_freelists.org
Subject: Not able to find data file on server but database is working fine

Hi,

On the test machine the developer created a new tablespace and I can see in the alert.log file that the command was successful. Also I can see from dba_data_fies that the datafile is available and also the tablespace is showing as Online in dba_tablespaces. Also I am able to create and insert data into table created in this tablespace but problem is I don't see the file on server and I done search(find) as root and don't see file anywhere on the system. Where the file can be and what can be the possible reason for this behavior? Environment: Oracle 10.2.0.3 on RHAT4

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l

---

CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.

To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 22 2007 - 15:05:15 CDT