From oracle-l-bounce@freelists.org Tue Aug 17 09:50:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7HEouh05525 for ; Tue, 17 Aug 2004 09:50:56 -0500 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 i7HEouI05520 for ; Tue, 17 Aug 2004 09:50:56 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4DC7872CB3B; Tue, 17 Aug 2004 09:56:02 -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 10701-03; Tue, 17 Aug 2004 09:56:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4F4E572CB98; Tue, 17 Aug 2004 09:56:01 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 17 Aug 2004 09:54:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7BD5272C124 for ; Tue, 17 Aug 2004 09:54:29 -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 09031-38 for ; Tue, 17 Aug 2004 09:54:29 -0500 (EST) Received: from ext-nj2gw-2.online-age.net (ext-nj2gw-2.online-age.net [216.35.73.164]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA40272C0A8 for ; Tue, 17 Aug 2004 09:54:28 -0500 (EST) Received: from int-nj2gw-1.online-age.net (int-nj2gw-1 [3.159.236.65]) by ext-nj2gw-2.online-age.net (8.12.9/8.12.9/990426-RLH) with ESMTP id i7HEt6M0018610 for ; Tue, 17 Aug 2004 10:55:06 -0400 (EDT) Received: from cinmlef03.e2k.ad.ge.com (localhost [127.0.0.1]) by int-nj2gw-1.online-age.net (8.12.9/8.12.8/990426-RLH) with ESMTP id i7HEt4EE009081 for ; Tue, 17 Aug 2004 10:55:05 -0400 (EDT) Received: from CINMLVEM05.e2k.ad.ge.com ([3.159.213.73]) by cinmlef03.e2k.ad.ge.com with Microsoft SMTPSVC(5.0.2195.6673); Tue, 17 Aug 2004 10:55:01 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6562.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: (no subject) Date: Tue, 17 Aug 2004 10:53:54 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: (no subject) Thread-Index: AcSDsoxklmCAtJVDQK25q9RerfU2PQAtYDGg From: "Aragon, Gabriel (GE Commercial Finance)" To: X-OriginalArrivalTime: 17 Aug 2004 14:55:01.0147 (UTC) FILETIME=[2BEB7EB0:01C4846A] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 7760 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gabriel.aragon@ge.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org What about rman duplicate command? Is it possible to do this to migrate = from 8 to 9? Duplicate command is available from 8.1.5, but prior to = that version you can do it using individual commands.=20 My experience to duplicate using rman with different versions in Win2k = is not good, it was necessary to have similar versions in both servers, = but I know people who did this with different oracle versions in unix = w/o problem. See : Note:73974.1 - RMAN: Restoring an RMAN Backup to Another Node=20 Note:228257.1 - RMAN Duplicate Database in Oracle9i=20 http://download-east.oracle.com/docs/cd/B10500_01/server.920/a96566/rcmdu= pdb.htm GAP -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Seema Singh Sent: Lunes, 16 de Agosto de 2004 12:00 p.m. To: oracle-l@freelists.org Subject: (no subject) Hi, I want to move to new server on unix platform. Current : 8 database ,Oracleapplication 9i platform: UNIX purposed : 9i database,Oracleapplication 10g Platform :UNIX Please suggest which approach would be good with minimum interruption to = the=20 production enviornment. Which option would be good Export/Import OR we need to install the same=20 version of oracle on new server and then upgrade by keeping the view = with=20 minimum intrruption of production enviornment and less riskly? I'm thinking following plan ,please correct me if any. 1)Install OS on new db and application boxes 2)Set enviornment.change kernel parameters etc according to oracle = database=20 and applciation server and rebuild the kernel. 3)Install OS patches/packages if any. 4)Install Oracle9i DATABASE and Oracleapplication 10g on 2 diffrent = boxes. 5)Create database and map tablespaces according with currect. 6)take export on production and FTP to new box. 7)Import the data in usermode. 8)Configure the tns and listerner 9)test the applications 10)If all above 9 steps are successfully then plan for final migration. 11)We need to do either stop the application ,export the data,ftp the = data=20 to new mahcine and start import on new server OR PUT THE TABLESPACE INTO = READ ONLY MODE,LEAVE THE APPLICATION, TAKE EXPORT,FTP AND IMPORT. thx -seema _________________________________________________________________ Don't just search. Find. Check out the new MSN Search!=20 http://search.msn.click-url.com/go/onm00200636ave/direct/01/ ---------------------------------------------------------------- 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 -----------------------------------------------------------------