I am trying to refresh a test instance with data from production. I generated a control file script and then "recover database until cancel using backup" then I have fed 23 archive logs already and i'm not getting the "recovery cancelled successfully" message.
I keep getting this error:
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
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: '/DEV1/tablespace/DEV1/system01.dbf'
ORA-01112: media recovery not started