Skip to Main Content

Refreshing instance, recovery not working.

Dr. DBASep 25 2014 — edited Sep 26 2014

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}


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

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 24 2014
Added on Sep 25 2014