RE: Move datafiles, but can't delete them

Side note on this - while you can delete files that are in use by Oracle on UNIX, you have not actually deleted them until there are no processes accessing that file anymore. The file will no longer be there to other applications, but the space used by that now-deleted file will not be released until all of the processes accessing it close their file descriptors. Lsof and fuser are useful tools to track un-reclaimed space due to processes still accessing deleted files.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: mzito_at_gridapp.com
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com



> -----Original Message-----

> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On 

> Behalf Of Jared Still

> Sent: Tuesday, November 25, 2003 9:49 AM

> To: Multiple recipients of list ORACLE-L

> Subject: RE: Move datafiles, but can't delete them

> 

> 

> > In a way, it's better than Unix.  You can't delete Windows Oracle 

> > files while the database is open, but in Unix you can.

> 

> In a way, it's a real pain in the butt.

> 

> Try looking at log files that are held open by other apps

> while they write to them.  No problem on unix, often 

> impossible on windows.

> 

> No, I'm not talking about Oracle.  NetBackup for instance, on 

> windows it is often impossible to read the logfiles for a 

> backup in progress.

> 

> If you do happen to erroneously delete an open file on unix, 

> you can recover from it if you keep your wits about you 

> and don't panic.

> 

> Jared

> 

> On Tue, 2003-11-25 at 05:24, Mercadante, Thomas F wrote:

> > Luc,

> > 

> > The next time you bounce the database you will be able to 

> delete the 

> > files. Windows keeps a lock on these files for some odd reason.

> > 

> > In a way, it's better than Unix.  You can't delete Windows Oracle 

> > files while the database is open, but in Unix you can.

> > 

> > Tom Mercadante

> > Oracle Certified Professional

> > 

> > 

> > -----Original Message-----

> > Sent: Tuesday, November 25, 2003 8:09 AM

> > To: Multiple recipients of list ORACLE-L

> > 

> > 

> > Hi gurus,

> > 

> > Oracle 8.1.7.4 on Windows 2000

> > Yesterday I wanted to move 2 datafiles (for the same tablespace) to 

> > another disk.

> > 1- I placed my tablespace offline

> > 2- I copied my 2 datafiles

> > 3- I altered my controlfiles to reflect the new path

> > 4- I brought my tablespace back online

> > 5- I backuped up my controlfile to trace to make sure it 

> using the new 

> > path

> > 6- When I wanted to delete the 2 old datafiles, Windows 

> gave me an "sharing

> > violation" error.  

> > 

> > My question is Who using it?

> > 

> > My controlfiles are changed, when I query DBA_DATA_FILES, i'm using 

> > the new path. ....

> > I don't want to bounce my production database ....

> > 

> > Any ideas

> > 

> > TIA

> > Luc

> > 

> > ---------

> > Luc Demanche

> > AstraZeneca R&D Montreal

> > Oracle Database Administrator

> > 514.832.3200 x2356

> > 

> > 

> > --

> > Please see the official ORACLE-L FAQ: http://www.orafaq.net

> > -- 

> > Author: 

> >   INET: Luc.Demanche_at_astrazeneca.com

> > 

> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

> > San Diego, California        -- Mailing list and web 

> hosting services

> > 

> ---------------------------------------------------------------------

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

> > --

> > Please see the official ORACLE-L FAQ: http://www.orafaq.net

> > -- 

> > Author: Mercadante, Thomas F

> >   INET: NDATFM_at_labor.state.ny.us

> > 

> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

> > San Diego, California        -- Mailing list and web 

> hosting services

> > 

> ---------------------------------------------------------------------

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

> > 

> 

> 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.net

> -- 

> Author: Jared Still

>   INET: jkstill_at_cybcon.com

> 

> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

> San Diego, California        -- Mailing list and web hosting services

> ---------------------------------------------------------------------

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

> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: mzito_at_gridapp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).