Re: datafile_problem

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

Reference:
10g RMAN Benefits of Simplified Recovery Through Resetlogs. (Doc ID 472536.1)

The RESETLOGS operation creates a new incarnation of the database and resets the logs.
The Simplified Recovery Through Resetlogs (a feature of 10g) is also applicable for performing a recovery using a backup control file and opening the database with the RESETLOGS operation.
You can use the newly generated logs with an earlier incarnation of the database.


So, you should be able to recover that datafile without any problems.

Send me the output of ;

recover datafile 1;

It wanted the archivelogs from your right? Did you apply the archivelogs that recovery wanted from you?
Did you see the following outputs after applying all the necessary archivelogs?

"Log applied.
Media recovery complete."