Re: datafile_problem

Posted by ErmanArslansOracleBlog on Mar 07, 2017; 1:25pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-problem-tp2282p2291.html

ORA-16433 is unexpected actually.

What is the story behind this restore&recovery? You didn't tell anything?

I suspect your restore scneario is problematic.
I guess you have problems with your controlfile.
But these are only guesses, because I don't have any info about your environment and recovery scenario..

According to note: Manual Completion of a Failed RMAN Backup based Duplicate (Doc ID 360962.1), you can fix this by recreating the controlfile.

If the error "ORA-16433: The database must be opened in read/write mode" is returned, you must recreate the controlfile.  Often, when this error occurs, you are unable to issue "alter database backup controlfile to trace" which means you must manually compile the 'create controlfile' statement.  

So, recreate the controlfile and retry the recovery.