From oracle-l-bounce@freelists.org Tue Oct 4 10:26:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j94FQ854014709 for ; Tue, 4 Oct 2005 10:26:08 -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 j94FPdvX014581 for ; Tue, 4 Oct 2005 10:25:39 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4C0751F14B8; Tue, 4 Oct 2005 10:24:55 -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 24459-06; Tue, 4 Oct 2005 10:24:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA2F61F1D07; Tue, 4 Oct 2005 10:24:54 -0500 (EST) Message-ID: <43429E4C.9040603@pacbell.net> Date: Tue, 04 Oct 2005 08:22:52 -0700 From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: Creating a controlfile - language needed? References: <4001DEAF7DF9BD498B58B45051FBEA6502D43D65@25exch1.vicorpower.vicr.com> In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502D43D65@25exch1.vicorpower.vicr.com> Content-Type: text/plain; charset=us-ascii; format=flowed X-archive-position: 26270 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: makbo@pacbell.net Precedence: normal Reply-To: makbo@pacbell.net 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-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Goulet, Dick wrote: > Depends. Was the database shutdown cleanly before you rebuilt the > control file? If not then you need it. Not exactly. If instance recovery is required, it is the online redo log files that you will need, not the original control file. > > I am copying a database to a new server and all of the 200+ files will > have > a new directory structure (but will keep the same SID) so that is why I > am > creating a new controlfile. > Why create a new controlfile and open resetlogs when you don't need to? Shutdown the database, copy all the files to the new locations, startup nomount, then use a series of ALTER DATABASE RENAME FILE commands to update the location of datafiles and online log files. Then create/drop tempfiles as appropriate. You still have to do the same amount of text file editing in either case. In fact, you might even get away with simply using DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters. -- Mark Bole http://www.bincomputing.com -- http://www.freelists.org/webpage/oracle-l