OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database not start

Tue, 21 December 2004 20:46

Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan

Member

When i start database i got this message

ORA-01113: File 7 need media recovery
ORA-01110: 7: 'D:ORACLEORADATAORCLDR01.DBF'

Tue, 21 December 2004 20:59

Sachin
Messages: 52
Registered: May 2001

Member

You need to recover the database file (file # 7) from backup.

The database file is not the latest one.

Sachin

Tue, 21 December 2004 22:28

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

Before you try anything drastic, try the following:

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

Best regards.

Frank

Previous Topic:	Problem while running the Listener
Next Topic:	index rebuild offline

Goto Forum:

]

Current Time: Thu Jan 09 22:50:14 CST 2025