ALTER DATABASE RECOVER database until time '2013-11-13:21:04:09' using backup controlfile;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/oracle/HO6/sapdata6/crm09d_101/crm09d.data101'
Please check Oracle support id : DATAFILE NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110 (Doc ID 1528788.1)
Thank you very much for this very interesting answer.
I read the suggested metalink note, and I found this note very usefull.
but, in this note, I found that we cannot open resetlogs the database after recover until ANY or ANY SCN ...
and this is what I don'understand ...
for me, if all datafiles are covered until one SCN, we can open database with resetlogs.
because, on every SCN the database is in consistent state.
Am I wrong ?
Can you post the result
select distinct checkpoint_change# from v$datafile_header;
select hxfil file_id, fhscn scn, fhthr thread, fhrba_seq sequence, fhsta status from x$kcvfh
Hello, too late the database was recovered until a sufficient SCN and opened with reserlogs.
I Will open another post to speak about why we cannot recover until any scn.
thanks for all.