Re: RMAN restore/recover problem

I assume that ALL the required archived log backups were also restored from tape, and catalogued?

> unable to find archived log
> archived log thread=1 sequence=1

Sounds like you are trying to recover from a starting point that is a previous incarnation. When you hit the thread=1 sequence=1 point in the recovery, you are applying the first archived log after the previous OPEN RESETLOGS. There's some stuff here about it -
http://qdosmsq.dunbar-it.co.uk/blog/2012/05/oracle-rman-for-beginners-part-8/

Scroll down to "Restoring a Database Through a Resetlogs" where you will see archived logs being applied as part of the recover command, and the sequence drops down to 1 again as the recovery passes through the previous resetlogs.

> ORA-01190: control file or data file 1 is from before the last RESETLOGS
> ORA-01110: data file 1: '/u31/oradata/DWHPRD/system01.dbf'

This is definitely telling me that you are recovering through a reset. This wasn't possible before 11g, but from 11g onwards - I assume 11.1 - this was possible in RMAN. My blog examples all use 11.2 for the demonstrations.

> 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.

The sequence resets to 1 after an open resetlogs. Try the list incarnations command in RMAN for your database. It will show you the previous incarnations and when the last resetlogs was carried out.

> Any pointers very greatly appreciated.
HTH Cheers,
Norm.

PS. I'm not an RMAN expert, nor do I play one on TV!

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l