-
Dear all,
Received a call saying the database cannot up the error message as below
ORA:01113 file2 needs media recovery
ORA:01110 Data File 2.....
Thus,
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 ....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|