| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: when does the lost datafile get noticed
Is it safe that I run "ALTER SYSTEM CHECK DATAFILES;" anytime in a production system? Thanks.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[ mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alexander Gorbachev
Sent: Friday, March 04, 2005 4:01 PM
To: ganstadba_at_hotmail.com
Cc: oracle-l_at_freelists.org
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_at_dp7uptx.com 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.
 |
 |