From oracle-l-bounce@freelists.org Fri Mar 4 17:47:22 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j24NlM0t012004 for ; Fri, 4 Mar 2005 17:47:22 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j24NlMem012000 for ; Fri, 4 Mar 2005 17:47:22 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A0FEA7E658; Fri, 4 Mar 2005 17:45:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02124-10; Fri, 4 Mar 2005 17:45:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 155057E656; Fri, 4 Mar 2005 17:45:54 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: roger_xu@dp7uptx.com X-Msg-Ref: server-6.tower-55.messagelabs.com!1109976250!34573312!1 X-StarScan-Version: 5.4.11; banners=dp7uptx.com,-,- X-Originating-IP: [216.136.17.254] X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: when does the lost datafile get noticed Date: Fri, 4 Mar 2005 16:43:58 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: when does the lost datafile get noticed Thread-Index: AcUhBdE4LuZDCmA6TfqhherAgtFVhQABa7kQ From: "Roger Xu" To: Cc: X-archive-position: 16992 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: roger_xu@dp7uptx.com Precedence: normal Reply-To: roger_xu@dp7uptx.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=EXCUSE_16 autolearn=no version=2.60 X-Spam-Level: Is=20it=20safe=20that=20I=20run=20"ALTER=20SYSTEM=20CHECK=20DATAFILES;"=20= anytime=20in=20a=20production=20system?=20Thanks. -----Original=20Message----- From:=20oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On=20Behalf=20Of=20Alexander=20Gorba= chev Sent:=20Friday,=20March=2004,=202005=204:01=20PM To:=20ganstadba@hotmail.com Cc:=20oracle-l@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@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@dp7uptx.com= . -- http://www.freelists.org/webpage/oracle-l