Re: when does the lost datafile get noticed
- From: Peter Gram <peter.gram@xxxxxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Fri, 04 Mar 2005 15:51:45 +0100
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
>--
>//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@xxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
