Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 13419 invoked from network); 10 Oct 2008 14:55:03 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 10 Oct 2008 14:55:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60E35A3A0F7; Fri, 10 Oct 2008 15:54:40 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00553-01-9; Fri, 10 Oct 2008 15:54:40 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA014A3A041; Fri, 10 Oct 2008 15:54:39 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 10 Oct 2008 15:52:38 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A14BEA3A029 for ; Fri, 10 Oct 2008 15:52:38 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32334-01 for ; Fri, 10 Oct 2008 15:52:38 -0400 (EDT) Received: from VA3EHSOBE002.bigfish.com (outbound-va3.frontbridge.com [216.32.180.16]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E497A3A006 for ; Fri, 10 Oct 2008 15:52:36 -0400 (EDT) Received: from mail81-va3-R.bigfish.com (10.7.14.248) by VA3EHSOBE002.bigfish.com (10.7.40.22) with Microsoft SMTP Server id 8.1.240.5; Fri, 10 Oct 2008 19:52:36 +0000 Received: from mail81-va3 (localhost.localdomain [127.0.0.1]) by mail81-va3-R.bigfish.com (Postfix) with ESMTP id 5707CD186F2 for ; Fri, 10 Oct 2008 19:52:36 +0000 (UTC) X-BigFish: VPS-27(zz2de7M62a3Laf6W103dKzzzzz2dh6bh62h) X-Spam-TCS-SCL: 1:0 X-FB-SS: 5, Received: by mail81-va3 (MessageSwitch) id 1223668354518030_18749; Fri, 10 Oct 2008 19:52:34 +0000 (UCT) Received: from spobmexc02.adprod.directory (smtp.riverbarges.com [12.23.250.36]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mail81-va3.bigfish.com (Postfix) with ESMTP id 5E8B015D8057 for ; Fri, 10 Oct 2008 19:52:34 +0000 (UTC) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C92B11.BCD3F3FD" Subject: Sanity Check Date: Fri, 10 Oct 2008 14:52:33 -0500 Message-ID: <17E4CDE8F84DC44A992E8C00767402E0861896@spobmexc02.adprod.directory> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Sanity Check From: "Taylor, Chris David" To: "ORACLE-L" X-archive-position: 11574 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Chris.Taylor@ingrambarge.com Precedence: normal Reply-to: Chris.Taylor@ingrambarge.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C92B11.BCD3F3FD Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Guys & Gals, =20 We have a database migration to new hardware tomorrow and this is something I was considering doing to save time tomorrow. I wanted to get a sanity check to see if I'm missing anything or have failed to consider anything. =20 1.) Restore prod database to the new machine (same name, same paths) tonight 2.) Shutdown prod database tomorrow and switch logfiles as part of the shutdown (shutdown trigger) to generate final archivelogs on old machine 3.) Copy archivelogs from old machine after shutdown to new machine 4.) Recover prod database on new machine 5.) Open prod database on new machine with resetlogs 6.) Take a backup of prod database =20 Do I run any risk of losing transactions in the existing prod database? =20 Anything I've failed to consider? =20 Thanks! =20 Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@ingrambarge.com =20 ------_=_NextPart_001_01C92B11.BCD3F3FD Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Guys = &=20 Gals,
 
We = have a database=20 migration to new hardware tomorrow and this is something I was = considering doing=20 to save time tomorrow.  I wanted to get a sanity check to see if = I'm=20 missing anything or have failed to consider = anything.
 
1.) = Restore prod=20 database to the new machine (same name, same paths) = tonight
2.) = Shutdown prod=20 database tomorrow and switch logfiles as part of the shutdown (shutdown = trigger)=20 to generate final archivelogs on old machine
3.) = Copy archivelogs=20 from old machine after shutdown to new machine
4.) = Recover=20 <new> prod database on new machine
5.) = Open <new>=20 prod database on new machine with resetlogs
6.) = Take a backup of=20 <new> prod database
 
Do I = run any risk of=20 losing transactions in the existing prod = database?
 
Anything I've failed to = consider?
 
Thanks!
 
Chris=20 Taylor
Sr. Oracle=20 DBA
Ingram Barge = Company
Nashville, TN = 37205
Office: = 615-517-3355
Cell: = 615-354-4799
Email: chris.taylor@ingrambarge.com=
 
------_=_NextPart_001_01C92B11.BCD3F3FD-- -- http://www.freelists.org/webpage/oracle-l