Is it safe that I run "ALTER SYSTEM CHECK DATAFILES;" anytime in a production system? Thanks. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Alexander Gorbachev Sent: Friday, March 04, 2005 4:01 PM To: ganstadba@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: 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-l For technical support please email tech_support@xxxxxxxxxxx or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@xxxxxxxxxxxx -- http://www.freelists.org/webpage/oracle-l