Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: when does the lost datafile get noticed
ALTER SYSTEM CHECK DATAFILES; - that would write error in alert.log if
something wrong. Otherwise, it'll be quite.
That's what I do immediately after I remove(rename) the file (well a soft link to to logical volume as we are mostly in RAC). After checking alert.log I can remove the file completely.
Alex
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 04 2005 - 17:04:12 CST