Hi,My database is in non archive log mode. I have the backup of all the datafiles, control files and redologs (cold backup). while my instance is running and when i entered some data into a table which is on a particular datafile which is lost physically by some mistake. i issued commit after entering data. when i tried to shut down normally i'm getting
error saying that unable to open the datafile.when i shut the instance forcefully(shut abort) and copied the lost datafile from backup to original location and tried to start the instance im getting the media recovery error .what to do in this situation. please help me in his situation.
Thanks in advance