recover database until time using backup controlfile is not working it is taking current log file only
to recover upto perticular time what to do
i used recover database using backup controlfile until time 'time'
iam getting this msg
SQL> recover database using backup controlfile until time '28-Feb-2008 10:00:00'
ORA-00279: change 339559282 generated at 03/09/2008 12:23:01 needed for thread
1
ORA-00289: suggestion : F:\ORA9IAS\RDBMS\ARC01901.001
ORA-00280: change 339559282 for thread 1 is in sequence #1901
Specify log: {=suggested | filename | AUTO | CANCEL}
f:\ora9ias\oradata\iasdb\redo02.log
ORA-00310: archived log contains sequence 1899; sequence 1901 required
ORA-00334: archived log: 'F:\ORA9IAS\ORADATA\IASDB\REDO02.LOG'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:\ORA9IAS\ORADATA\IASDB\SYSTEM01.DBF'