Re: datafile_problem

Posted by ErmanArslansOracleBlog on Mar 08, 2017; 6:56am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-problem-tp2282p2298.html

You need to recover a little bit more,

send me the output of following ->

sqlplus "/as sysdba"

SQL>select HXFIL File_num,substr(HXFNM,1,40) File_name, FHSCN SCN, FHSTA status ,FHRBA_SEQ Sequence from X$KCVFH;

Ref:Unable to open the database in read only mode after restore/recovery (Doc ID 316154.1)