Home » RDBMS Server » Server Administration » Oraclexe - file 1 needs media recovery (OracleXE 11.2.0)
Oraclexe - file 1 needs media recovery [message #649970] Mon, 11 April 2016 13:22 Go to next message
mape
Messages: 243
Registered: July 2006
Location: Slovakia
Senior Member
Hi

I need a help about right installation of Oracle XE.

Whenever I do a new installation OracleXe 11.2.0 on Windows 7 Ultimate,
after startup database I will get an error:

Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


I tried to anything what I have found out on internet about that ORA error message
but nothing was ok.

Does anybody could tell me how to strugle with this problem??

thanks a lot

Martin

[Updated on: Mon, 11 April 2016 13:24]

Report message to a moderator

Re: Oraclexe - file 1 needs media recovery [message #649971 is a reply to message #649970] Mon, 11 April 2016 13:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you tried everything then nothing can be tried now.
Recreate your database.

[Updated on: Mon, 11 April 2016 13:54]

Report message to a moderator

Re: Oraclexe - file 1 needs media recovery [message #649972 is a reply to message #649970] Mon, 11 April 2016 14:08 Go to previous messageGo to next message
mape
Messages: 243
Registered: July 2006
Location: Slovakia
Senior Member

I did reistall a many times and the ORA error is the same.
I dont know how to resolve it.
Re: Oraclexe - file 1 needs media recovery [message #649973 is a reply to message #649972] Mon, 11 April 2016 14:12 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As you already have tried everything, nothing can be done.
And reinstalling Oracle is useless in this problem, but you already know that as you already read everything that is in Internet and nowhere you have seen that reinstalling Oracle will help in any way.

Re: Oraclexe - file 1 needs media recovery [message #650005 is a reply to message #649972] Tue, 12 April 2016 07:16 Go to previous message
John Watson
Messages: 7265
Registered: January 2010
Location: Global Village
Senior Member
What do you get if you issue a RECOVER DATABASE; command?
Previous Topic: memory issues and problem
Next Topic: Record remains locked even after DB server restart
Goto Forum:
  


Current Time: Sat Feb 24 16:43:11 CST 2018

Total time taken to generate the page: 0.00972 seconds