| ORA-01113: file 1 needs media recovery [message #569491] |
Sat, 27 October 2012 08:54  |
mape
Messages: 298
Registered: July 2006
Location: Slovakia
|
Senior Member |
|
|
Hello
I just installed Oracle XE on my local computer Windows 7.
When I run STARTUP command I get this error:
SQL> startup;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1384760 bytes
Variable Size 226496200 bytes
Database Buffers 301989888 bytes
Redo Buffers 5791744 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'
I try to fix it by recover but unsuccessfully:
SQL> recover datafile 'D:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
Does anybody know what can I do to fix it ?
thanks a lot
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01113: file 1 needs media recovery [message #569497 is a reply to message #569495] |
Sat, 27 October 2012 14:39  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Well, the same combination works just fine for me.
As you have just installed it, maybe you should now uninstall it, completely, reboot the computer and start the installation process once again. Pay attention to possible messages you receive which might point to something unexpected (although, I can't imagine what might go wrong in that simple task).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
