RMAN restore/recover problem
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-lReceived on Wed Aug 28 2013 - 16:01:36 CEST