Re: when does the lost datafile get noticed

Michael
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 :-)

/peter

Michael McMullen wrote:

>Oracle 9.2.0.6
>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.
>
>Thanks
>Mike
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Best regards / Venlig hilsen

/*Peter Gram*/
Miracle A/S <http://www.miracleas.dk>
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
Email: peter.gram_at_miracleas.dk

 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 
accounts,
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


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