RE: rman nocatalog - point in time recovery
- From: "Mike Killough" <mwkillough@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Jul 2004 20:41:10 +0000
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
