Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman nocatalog - point in time recovery

RE: rman nocatalog - point in time recovery

From: Mike Killough <mwkillough_at_hotmail.com>
Date: Tue, 13 Jul 2004 20:41:10 +0000
Message-ID: <BAY17-F37BjUeiLiwWV00090a7b@hotmail.com>


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 <last sequence> thread 1; fails
symptom: RMAN-20206 : log sequence not found in the recovery catalog cause: The statement
recover database until logseq <last sequence> 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 <scn matching logfile>; 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_at_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
Received on Tue Jul 13 2004 - 15:38:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US