how to recover the DB from a dmp file?

From: Fabio Zanotti <>
Date: Mon, 30 Jun 2008 06:49:17 -0700 (PDT)
Message-ID: <>

Hi all,
we had corrupted one datafile and now the DB could not be open, but can be
mount. Unfortunately, we are running our DB in NOARCHIVE mode and we don't have a backup
too. We have a full dmp file only.

ORACLE instance started.

Total System Global Area 27480224 bytes

Fixed Size                    73888 bytes
Variable Size              18845696 bytes
Database Buffers            8388608 bytes
Redo Buffers                 172032 bytes
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/opt/oracle/oradata/st0918bo/indx01.dbf'

plz. help me, how to recover the DB from a dmp file?.


Fabio Zanotti. Received on Mon Jun 30 2008 - 08:49:17 CDT

Original text of this message