From oracle-l-bounce@freelists.org Sun Aug 8 17:12:04 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i78MC4o10870 for ; Sun, 8 Aug 2004 17:12:04 -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 i78MC4I10865 for ; Sun, 8 Aug 2004 17:12:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1406B72C20A; Sun, 8 Aug 2004 17:02:34 -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 12868-10; Sun, 8 Aug 2004 17:02:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5662372C075; Sun, 8 Aug 2004 17:02:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 08 Aug 2004 17:01:08 -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 4FC7E72C31B for ; Sun, 8 Aug 2004 17:01:08 -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 12472-21 for ; Sun, 8 Aug 2004 17:01:08 -0500 (EST) Received: from mail.cybcon.com (mail.cybcon.com [216.190.188.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A676472C2A7 for ; Sun, 8 Aug 2004 17:01:07 -0500 (EST) Received: from dsl2-6 (dsl2-6.cybcon.com [208.186.116.6]) by mail.cybcon.com (8.11.6/8.11.6) with ESMTP id i78MGEp16397 for ; Sun, 8 Aug 2004 15:16:14 -0700 Subject: Re: BAARF - true life story From: Jared Still To: Oracle-L Freelists In-Reply-To: <20040807191856.BAGA20378.fed1rmmtao07.cox.net@smtp.west.cox.net> References: <20040807191856.BAGA20378.fed1rmmtao07.cox.net@smtp.west.cox.net> Content-type: text/plain Message-Id: <1092003970.30895.471.camel@poirot> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sun, 08 Aug 2004 15:26:10 -0700 Content-Transfer-Encoding: 8bit X-CyberConnectics-MailScanner2-Information: Spam/Virus Scanned at CyberConnectics X-CyberConnectics-MailScanner2: Found to be clean X-CyberConnectics-MailScanner2-SpamCheck: X-MailScanner-From: jkstill@cybcon.com X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 7167 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@cybcon.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Sat, 2004-08-07 at 12:18, solbeach@cox.net wrote: > We now have to move this whole database (178GB) to a new > system, with minimal downtime. > ... > What would YOU do given this history & requirements? > Just off the top of my head, without giving it a great deal of thought ( that's your job :) * hot backup the database to another server ( manual scripts or RMAN, your choice ) * recover it to the current set of arhive logs, shut it down, and run dbverify on all data files * continue if all is ok. If not ok, well then, you gotta figure out which blocks are bad and attempt to recover them * recover the new database to the current set of archive logs, shutdown the old database, startup restrict, switch logfiles, shutdown the database and apply the final archive log file to the new database. * this doesn't cause much downtime. 10 minutes or so if you test it first and write down exact instructions. * test this before doing it for real Jared ---------------------------------------------------------------- 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 -----------------------------------------------------------------