RMAN restore/recover problem

From: Holvoet, Jo <jo.holvoet_at_thomascook.be>
Date: Wed, 28 Aug 2013 16:01:36 +0200
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF7049529C1_at_SW-GNETCW-MBX02.tcads.thomascook.com>



Hello all,  

I'm trying to do a PITR of an 11.1.0.7 database.

Backupsets were restored from tape and I registered them in our RMAN catalog.  

The restore works fine, but the recover fails with :  

unable to find archived log

archived log thread=1 sequence=1

Oracle Error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01190: control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: '/u31/oradata/DWHPRD/system01.dbf'  

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 08/28/2013 15:53:44

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1 and starting SCN of 2635  

Sequence 1 ??? Why is it asking for archive log sequence 1 ?

The archive logs I would expect to be used have sequence numbers upwards of 60000 or so and are in the catalog.  

Any pointers very greatly appreciated.  

Mvg/regards

Jo

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 28 2013 - 16:01:36 CEST

Original text of this message