From oracle-l-bounce@freelists.org Tue Apr 5 11:09:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j35G9bqf020119 for ; Tue, 5 Apr 2005 11:09:37 -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 j35G9aem020114 for ; Tue, 5 Apr 2005 11:09:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DEAC991255; Tue, 5 Apr 2005 10:07:32 -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 27659-06; Tue, 5 Apr 2005 10:07:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 647CF9121A; Tue, 5 Apr 2005 10:07:32 -0500 (EST) Message-ID: From: "Mercadante, Thomas F" To: "'lucdemanche@gmail.com'" , oracle-l@freelists.org Subject: RE: Transfer of a database from AIX5.1 to AIX5.2 Date: Tue, 5 Apr 2005 11:05:41 -0400 MIME-Version: 1.0 Content-type: text/plain X-OriginalArrivalTime: 05 Apr 2005 15:05:44.0796 (UTC) FILETIME=[F0FCC9C0:01C539F0] Content-Transfer-Encoding: 8bit X-archive-position: 18055 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Luc, This should be fine. As a test, I would create a small database and copy that one over first. Open it and do a couple of queries to make sure all works ok. We upgraded from 5.1 to 5.2 on our existing box. I did nothing to the database and it came up fine. Just for grins, we did an Oracle relink all and did our tests again. Again, all was fine. One thing that you should check though is whether 8.1.7 is supported on AIX 5.2. Tom -----Original Message----- From: Luc Demanche [mailto:lucdemanche@gmail.com] Sent: Tuesday, April 05, 2005 9:29 AM To: oracle-l@freelists.org Subject: Transfer of a database from AIX5.1 to AIX5.2 Hi, Oracle 8.1.7, AIX5.1 We have to transfer some database from one server running on AIX5.1 to a server running AIX5.2 My first proposition (and the easier) was to take a coldbackup and transfer it to the new server. The sysadmin told me yesterday that he wants to install AIX5.2 on the new server. We will stay with Oracle8.1.7. My question is, will my coldbakcup be good even if the OS change from AIX5.1 to AIX5.2? If not, I guess that my only option is Export/Import? Thank you Luc -- Luc Demanche Oracle DBA (514) 867-9977 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l