OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » media recovery

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

media recovery [message #232980]

Tue, 24 April 2007 06:23

azamkhan
Messages: 557
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

Report message to a moderator

Re: media recovery [message #233008 is a reply to message #232980]

Tue, 24 April 2007 06:56

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: media recovery [message #233032 is a reply to message #233008]

Tue, 24 April 2007 07:31

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

Report message to a moderator

Re: media recovery [message #233041 is a reply to message #232980]

Tue, 24 April 2007 07:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try:
recover automatic datafile 3;

Regards
Michel

Report message to a moderator

Previous Topic:	Recovery Catalog related problem...
Next Topic:	About RMAN backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 03:19:53 CST 2024