Received a call saying the database cannot up the error message as below
ORA:01113 file2 needs media recovery
ORA:01110 Data File 2.....
svrmgr> startup mount
svrmgr> alter database datafile 'c:.....' offline drop;
svrmgr> alter database open;
I created another owner in order for me to import from backup file.
Next day, I discovered the datafile is being hide by 'someone' and the permission of the file is read only.
Question is can I still recover my datafile from my physical datafile ? This is no archivelog mode. I just set it archivelog mode.
Any ideas to recover back if without archive log mode ? Please help me on this ....
Click Here to Expand Forum to Full Width