From oracle-l-bounce@freelists.org Thu Nov 11 20:47:37 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAC2lbs21385 for ; Thu, 11 Nov 2004 20:47:37 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAC2lba21380 for ; Thu, 11 Nov 2004 20:47:37 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AA330732F2A; Thu, 11 Nov 2004 21:31: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 04599-98; Thu, 11 Nov 2004 21:31:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6525372CE8D; Thu, 11 Nov 2004 19:25:37 -0500 (EST) From: "Mark W. Farnham" To: , "Oracle-L" Subject: RE: doh! stupid datafiles Date: Thu, 11 Nov 2004 16:46:02 -0500 Message-ID: MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: X-archive-position: 12148 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mwf@rsiz.com Precedence: normal Reply-To: mwf@rsiz.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 2 datafiles with how much contents, and how big compared to the rest of the database? Now those 2 datafiles are all of one or two tablespaces, and if you can make do with just the contents of those two tablespaces from the production database with no referential integrity problems or things out of balance type issues, you might consider just sqlplus copy or unload script -> loader or exp/imp of just the objects in the tablespaces affected by the loss of those two files. If there are integrity issues, by all means re-clone production, but if not, it is possible you'll do a lot less work by just getting back what you lost. Regards, mwf -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Bryan Wells Sent: Thursday, November 11, 2004 11:40 AM To: Oracle-L Subject: doh! stupid datafiles Running 8.1.7 on Solaris 8. Yesterday I deleted 2 datafiles, luckily in a non-production environment. However, this system does not get backed up. Im thinking I am most likely stuck recreating this database from the production instance. is this my only option, and what is the doc id in metalink that can walk me through this. -- Bryan S Wells bunjibry@gmail.com -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l