ORA-00328 archived log ends

Jul 13, 2014 1:56AM

Hi,

on 11.2.0.3 I do recover using backup controlfile. It suggests a file and I give the same file but I receive that error :

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 1147557 generated at 07/13/2014 07:38:41 needed for thread 1

ORA-00289: suggestion : C:\ARCH\ORCL\ARC0000000010_0852665279.0001

ORA-00280: change 1147557 for thread 1 is in sequence #10

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

C:\ARCH\ORCL\ARC0000000010_0852665279.0001

ORA-00328: archived log ends at change 1145554, need later change 1147557

ORA-00334: archived log: 'C:\ARCH\ORCL\ARC0000000010_0852665279.0001'

Then if C:\ARCH\ORCL\ARC0000000010_0852665279.0001 was not good why it was suggested ?

How to say to recover just to 1145554 ?

Thank you.

Database Administration (MOSC)