From oracle-l-bounce@freelists.org Tue Sep 20 08:08:57 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8KD8vx9017988 for ; Tue, 20 Sep 2005 08:08:57 -0500 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 j8KD8r6H017973 for ; Tue, 20 Sep 2005 08:08:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E12321EE9C8; Tue, 20 Sep 2005 08:08:41 -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 31526-10; Tue, 20 Sep 2005 08:08:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E7CD1EEBCE; Tue, 20 Sep 2005 08:08:41 -0500 (EST) Message-ID: <33678E78A2DD4D418396703A750048D4010255AD@RIKER> From: Branimir Petrovic To: oracle-l@freelists.org Subject: RE: Database recovery problem Date: Tue, 20 Sep 2005 09:06:50 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5BDE4.2A3D49E0" X-archive-position: 25665 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: BranimirP@cpas.com Precedence: normal Reply-To: BranimirP@cpas.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5BDE4.2A3D49E0 Content-Type: text/plain; charset="iso-8859-1" Try as hard as you may - you can not delete any Oracle data files on Windows (should have said - on Windows ONLY) while the database is up and running. Windows keeps them locked 'n safe from deletion attempts. However, take the tablespace offline and watch its individual data files become "fair game" for deletion attempts... The story you've been told on how the problem came to be - simply ain't true. It takes more than a simple mistake (on Windows that is) to get to this point. FYI - it takes *deliberate* aim. Branimir P.S. If there are no recent cold backups (or schema exports) - expect from partial to total data loss. If data loss is not acceptable - somebody should get "walking papers" over this. -----Original Message----- From: Onkar N Tiwary [mailto:onkarnath.tiwary@gmail.com] Sent: Tuesday, September 20, 2005 7:55 AM To: oracle-l@freelists.org Subject: Database recovery problem hi all, We have got one oracle 9i rel 2 on windows 2000 running in no-archive log mode. the problem is one of the dba of the other team has deleted some of the dbf files while the database was running and tablespace was online. ------_=_NextPart_001_01C5BDE4.2A3D49E0 Content-Type: text/html; charset="iso-8859-1"
Try as hard as you may - you can not delete any Oracle data files on
Windows (should have said - on Windows ONLY) while the database is up
and running. Windows keeps them locked 'n safe from deletion attempts.
However, take the tablespace offline and watch its individual data
files become "fair game" for deletion attempts...
 
The story you've been told on how the problem came to be - simply ain't
true. It takes more than a simple mistake (on Windows that is) to get
to this point. FYI - it takes *deliberate* aim.
 
Branimir
 
P.S.
 
If there are no recent cold backups (or schema exports) - expect from
partial to total data loss. If data loss is not acceptable - somebody
should get "walking papers" over this.
 
 
-----Original Message-----
From: Onkar N Tiwary [mailto:onkarnath.tiwary@gmail.com]
Sent: Tuesday, September 20, 2005 7:55 AM
To: oracle-l@freelists.org
Subject: Database recovery problem

hi all,
 
We have got one oracle 9i rel 2 on windows 2000 running in no-archive log mode. the problem is one of the dba of the other team has deleted some of the dbf files while the database was running and tablespace was online.
------_=_NextPart_001_01C5BDE4.2A3D49E0-- -- http://www.freelists.org/webpage/oracle-l