RE: when does the lost datafile get noticed

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Fri, 4 Mar 2005 16:43:58 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F7059C930D@irv2kexch01>

Is=20it=20safe=20that=20I=20run=20"ALTER=20SYSTEM=20CHECK=20DATAFILES;"=20= anytime=20in=20a=20production=20system?=20Thanks.

-----Original=20Message-----

From:=20oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On=20Behalf=20Of=20Alexander=20Gorba= chev
Sent:=20Friday,=20March=2004,=202005=204:01=20PM To:=20ganstadba_at_hotmail.com
Cc:=20oracle-l_at_freelists.org
Subject:=20Re:=20when=20does=20the=20lost=20datafile=20get=20noticed

ALTER=20SYSTEM=20CHECK=20DATAFILES;=20-=20that=20would=20write=20error=20i= n=20alert.log=20if
something=20wrong.=20Otherwise,=20it'll=20be=20quite.

That's=20what=20I=20do=20immediately=20after=20I=20remove(rename)=20the=20=

file=20(well=20a
soft=20link=20to=20to=20logical=20volume=20as=20we=20are=20mostly=20in=20R=
AC).=20After

checking=20alert.log=20I=20can=20remove=20the=20file=20completely.

Alex
--

http://www.freelists.org/webpage/oracle-l

For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or= =20you=20can
call=20(972)721-8257.=20
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes= sageLabs=20Email=20Security=20System.

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=

g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20= entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20= have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s= ender=20immediately=20and=20delete=20the=20material.=20

This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=

.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 04 2005 - 17:47:22 CST