Home » RDBMS Server » Server Administration » ORA-01113: file 1 needs media recovery (Oracle Database 11g Express Edition (Oracle Database XE) )
ORA-01113: file 1 needs media recovery [message #569491] Sat, 27 October 2012 08:54 Go to next message
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 #569492 is a reply to message #569491] Sat, 27 October 2012 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
which Edition of Windows 7?
Re: ORA-01113: file 1 needs media recovery [message #569493 is a reply to message #569492] Sat, 27 October 2012 10:58 Go to previous messageGo to next message
mape
Messages: 298
Registered: July 2006
Location: Slovakia
Senior Member
Sorry, not Windows 7 but Windows XP
Re: ORA-01113: file 1 needs media recovery [message #569494 is a reply to message #569493] Sat, 27 October 2012 11:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK then: which XP edition do you have? Generally speaking, Oracle might not work properly on any Windows Home edition.
Re: ORA-01113: file 1 needs media recovery [message #569495 is a reply to message #569494] Sat, 27 October 2012 11:11 Go to previous messageGo to next message
mape
Messages: 298
Registered: July 2006
Location: Slovakia
Senior Member

Im sorry, Ive made a mistake due to my two computers, I got Oracle XE installed on Windows 7 Enterprise Service Pack 1
Re: ORA-01113: file 1 needs media recovery [message #569497 is a reply to message #569495] Sat, 27 October 2012 14:39 Go to previous message
Littlefoot
Messages: 21806
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).
Previous Topic: Table Statistics for oracle 11g
Next Topic: How to refresh test Schema from Production request
Goto Forum:
  


Current Time: Fri Mar 29 10:33:55 CDT 2024