Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i12GvG015855 for ; Mon, 2 Feb 2004 10:57:16 -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 i12GvBo15836 for ; Mon, 2 Feb 2004 10:57:12 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5063F394FF0; Mon, 2 Feb 2004 11:50:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 02 Feb 2004 11:49:04 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from agminet03.oracle.com (agminet03.oracle.com [141.146.126.230]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 11FDB394F37 for ; Mon, 2 Feb 2004 11:48:55 -0500 (EST) Received: from rgmgw5.us.oracle.com (rgmgw5.us.oracle.com [138.1.191.14]) by agminet03.oracle.com (Switch-3.1.2/Switch-3.1.0) with ESMTP id i12GoVgd009677 for ; Mon, 2 Feb 2004 08:52:08 -0800 Received: from rgmgw5.us.oracle.com (localhost [127.0.0.1]) by rgmgw5.us.oracle.com (Switch-2.1.5/Switch-2.1.0) with ESMTP id i12GoUM15150 for ; Mon, 2 Feb 2004 09:50:31 -0700 (MST) Received: from PETE (dhcp-amer-vpn-gw2-east-141-144-84-31.vpn.oracle.com [141.144.84.31]) by rgmgw5.us.oracle.com (Switch-2.1.5/Switch-2.1.0) with ESMTP id i12GoPM14952 for ; Mon, 2 Feb 2004 09:50:26 -0700 (MST) From: "Pete Sharman" To: Subject: RE: replicating an instance Date: Tue, 3 Feb 2004 03:50:25 +1100 Message-ID: <00cf01c3e9ac$ac2071c0$6f4f8790@PETE> MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <24ce01c3e8c8$675b0f30$a1e16444@ryan2le36ofjce> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Brightmail-Tracker: AAAAAQAAAAI= X-White-List-Member: TRUE X-archive-position: 559 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l And of course, in addition to the answers you've already received which cover what you really wanted to do rather than what you asked for, remember you're copying the database, not the instance! :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ryan Sent: Monday, February 02, 2004 12:37 AM To: oracle-l@freelists.org Subject: replicating an instance I do development so please bare with the stupid question. To copy an instance I do the following right? 1. Shut down the instance 2. Copy all data files to the new locations 3. Change the DB_NAME, dump directories, and redo log paths in the init.ora file 4. startup nomount. Rename the redo logs 5. Create control file 6. Open database. I think Im missing some steps. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------