OraFAQ Forum: Backup & Recovery » How to tackle Media Recovery?

Home » RDBMS Server » Backup & Recovery » How to tackle Media Recovery?

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

How to tackle Media Recovery? [message #74256]

Sun, 24 October 2004 22:21

JoinNepal
Messages: 33
Registered: October 2003

Member

Hi,

my database was working properly but when I tried to log on to Database using SQLPLUS today, the message:

ORA-01113 : File 5 Needs Media Recovery and
ORA-01110 Data file 5 Tools01.dbf displayed

Let me get help to get rid of this message and to run my database smoothly.

Thank you.

Yours,
Roshan

Report message to a moderator

Re: How to tackle Media Recovery? [message #108945 is a reply to message #74256]

Sun, 20 February 2005 11:18

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try:

SQL> RECOVER DATAFILE 5;
SQL> ALTER DATABASE DATAFILE 5 ONLINE;

Best regards.

Frank

Report message to a moderator

Previous Topic:	RMAN - Incarnation
Next Topic:	Starting Oracle 8.0.5.22 in HP-UX 11.11

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:35:54 CDT 2024