Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: when does the lost datafile get noticed

Re: when does the lost datafile get noticed

From: Peter Gram <>
Date: Fri, 04 Mar 2005 15:51:45 +0100
Message-ID: <>

The Oracle database will not know that you have deleted the file and that is the reason that you
did not get any problems until you tried to close the database. When you delete a file on unix the file is not removed until all processes has closes the file.
This is the reason that the database did not complain about you're delete. The best way to test is file system on a mount point that you then can unmount force
since this will de noted by Oracle :-)


Michael McMullen wrote:

>solaris 9
>I was testing some rman stuff yesterday. I deleted a datafile from a users
>tablespace(only one datafile in the tablespace, they only had quota on that
>tablespace). I then monitored the alter log to see when it would show up. I
>also ran a bunch of queries on v$datafile, dba_data_files. I was able to
>keep creating tables as that user, insert/update delete, never any error. I
>issued numerouse alter system checkpoints, switched the logfiles over 10
>times (only have 3 redo logs). But nothing ever showed up as a problem. Only
>when I issued shutdown immediate did the error get puked out.
>Did I miss something? Is there another view I should be watching, or does
>this go back to the inode post a few days back.


Best regards / Venlig hilsen

/*Peter Gram*/
Miracle A/S <>
Kratvej 2
DK - 2760 Måløv

Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Skype:  peter_gram

 28 feb - 2.mar 2005  	 Database Master Class with Chris Date 
 30 Mar 2005  	 SQL Tuningsdag for Oracle-teknikere 
 2-4 May 2005  	 SQL Server Master Class with Kimberly Tripp 


A human being should be able to change a diaper, plan an invasion, 
butcher a hog, conn a ship, design a building, write a sonnet, balance 
build a wall, set a bone, comfort the dying, take orders, give orders, 
cooperate, act alone, solve equations, analyze a new problem, pitch manure,
program a computer, cook a tasty meal, fight efficiently, die gallantly. 
Specialization is for insects. - Robert A. Heinlein

Received on Fri Mar 04 2005 - 09:55:05 CST

Original text of this message