From oracle-l-bounce@freelists.org Tue Jul 13 14:21:19 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6DJL4w15173 for ; Tue, 13 Jul 2004 14:21:14 -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 i6DJKs615121 for ; Tue, 13 Jul 2004 14:21:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 268F372C132; Tue, 13 Jul 2004 14:01:23 -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 31924-35; Tue, 13 Jul 2004 14:01:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74BD872C076; Tue, 13 Jul 2004 14:01:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Jul 2004 13:59:53 -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 EE2CD72C1ED for ; Tue, 13 Jul 2004 13:59:26 -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 31246-20 for ; Tue, 13 Jul 2004 13:59:26 -0500 (EST) Received: from web52108.mail.yahoo.com (web52108.mail.yahoo.com [206.190.39.77]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 864DC72C02C for ; Tue, 13 Jul 2004 13:59:26 -0500 (EST) Message-ID: <20040713192412.9733.qmail@web52108.mail.yahoo.com> Received: from [137.148.2.12] by web52108.mail.yahoo.com via HTTP; Tue, 13 Jul 2004 12:24:12 PDT Date: Tue, 13 Jul 2004 12:24:12 -0700 (PDT) From: Mike Hennesy Subject: recovery error To: oracle-l@freelists.org MIME-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5002 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: orcl9ps8dba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I just had this dropped on my desk. Oracle 8.1.7.3 . The objective was to restore a backup of PRD on a different host and recover from the 6/30 5:00 AM backup until 7/1 at 4:30 AM. I was told that the media recovery complete was almost instantaneous (didn't show processing of any archive logs, should have processed 15) and the ALTER SYSTEM ARCHIVE LOG ALL took about 45 seconds to complete. The following file with datafiles removed was executed after connect internal. STARTUP NOMOUNT pfile=/u01/app/oracle/admin/fin/pfile/initprd.ora CREATE CONTROLFILE REUSE DATABASE "PRD" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 . . datafiles . CHARACTER SET WE8ISO8859P1 ; recover database until time '2004-07-01:04:30:00'; ALTER SYSTEM ARCHIVE LOG ALL; ALTER DATABASE OPEN; Produced the following. ORACLE instance started. Total System Global Area 966713504 bytes Fixed Size 73888 bytes Variable Size 693010432 bytes Database Buffers 253952000 bytes Redo Buffers 19677184 bytes Statement processed. SVRMGR> recover database until time '2004-07-01:04:30:00'; Media recovery complete. SVRMGR> ALTER SYSTEM ARCHIVE LOG ALL; Statement processed. SVRMGR> ALTER DATABASE OPEN; ALTER DATABASE OPEN * ORA-01589: must use RESETLOGS or NORESETLOGS option for database open I have access to the backed up files so I can restore what I need to. I'm not sure why the archive logs weren't processed. If anyone can shed some light I'd appreciate it. Do I have to recover all the datafiles? Thanks - Mike --------------------------------- Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! ---------------------------------------------------------------- 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 -----------------------------------------------------------------