From oracle-l-bounce@freelists.org Tue Jul 13 15:38:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6DKbmu29664 for ; Tue, 13 Jul 2004 15:37:58 -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 i6DKbb629634 for ; Tue, 13 Jul 2004 15:37:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 16DC972D23B; Tue, 13 Jul 2004 15:17:51 -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 11033-83; Tue, 13 Jul 2004 15:17:50 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5151972C9D1; Tue, 13 Jul 2004 15:17:50 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Jul 2004 15:16:25 -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 3F44872CE7C for ; Tue, 13 Jul 2004 15:16:25 -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 10646-69 for ; Tue, 13 Jul 2004 15:16:25 -0500 (EST) Received: from hotmail.com (bay17-f37.bay17.hotmail.com [64.4.43.87]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3C58172CF9F for ; Tue, 13 Jul 2004 15:16:24 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 13 Jul 2004 13:41:10 -0700 Received: from 66.28.242.66 by by17fd.bay17.hotmail.msn.com with HTTP; Tue, 13 Jul 2004 20:41:10 GMT X-Originating-IP: [66.28.242.66] X-Originating-Email: [mwkillough@hotmail.com] X-Sender: mwkillough@hotmail.com From: "Mike Killough" To: oracle-l@freelists.org Subject: RE: rman nocatalog - point in time recovery Date: Tue, 13 Jul 2004 20:41:10 +0000 Mime-Version: 1.0 Content-type: text/plain Message-ID: X-OriginalArrivalTime: 13 Jul 2004 20:41:10.0873 (UTC) FILETIME=[BB2EEC90:01C46919] X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5015 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mwkillough@hotmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Try using until time. From Metalink Note 216465.1: fact: Oracle Server - Enterprise Edition 8 fact: Oracle Server - Enterprise Edition 9 fact: Recovery Manager (RMAN) symptom: Rman recovery fails symptom: Rman incomplete recovery fails symptom: Rman statement recover database until logseq thread 1; fails symptom: RMAN-20206 : log sequence not found in the recovery catalog cause: The statement recover database until logseq thread 1; fails due to a bug fixed in 9.2 fix: Either perform a manual incomplete recovery SQL> recover database [using backup controlfile] until cancel; or use the Rman statements RMAN> set until scn ; or (date is an example) RMAN> set until time "2002-SEP-07 11:05:00"; # Assumes correct corresponding NLS_DATE_FORMAT _________________________________________________________________ Check out the latest news, polls and tools in the MSN 2004 Election Guide! http://special.msn.com/msn/election2004.armx ---------------------------------------------------------------- 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 -----------------------------------------------------------------