Home » RDBMS Server » Backup & Recovery » media recovery
media recovery [message #232980] Tue, 24 April 2007 06:23 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
When I tried to login to my database by a simple user it says tnsnames unable to resolve. But when I login as sysdba by SYSTEM user and tried to startup the database it stopped in mount mode and showed 2 messages
1- ORA-01113: file 3 needs media recover
2- ORA-01110: data file 3 'D:\Oracle\orcl1\drsys01.dbf'

Guys this is very urgent...! Plz if any one of you knows what to do then plz reply me.

Regards,
Azam Khan
Re: media recovery [message #233008 is a reply to message #232980] Tue, 24 April 2007 06:56 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe it is urgent, but - if you keep posting such a questions on the Forms forum, you won't get a proper answer very soon. What does Forms Builder have to do with media recovery?
Re: media recovery [message #233032 is a reply to message #233008] Tue, 24 April 2007 07:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
- ORA-01113: file 3 needs media recover
2- ORA-01110: data file 3 'D:\Oracle\orcl1\drsys01.dbf'


Insufficient information you have to give us more information about your problem. what you did before getting this error message.

and you have last valid backup.
Regards
Taj
Re: media recovery [message #233041 is a reply to message #232980] Tue, 24 April 2007 07:52 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try:
recover automatic datafile 3;

Regards
Michel
Previous Topic: Recovery Catalog related problem...
Next Topic: About RMAN backup
Goto Forum:
  


Current Time: Tue Dec 06 14:24:39 CST 2016

Total time taken to generate the page: 0.06254 seconds