how to recover the DB from a dmp file?

From: Fabio Zanotti <zanotti.fabio@xxxxxxxxx>
Date: Mon, 30 Jun 2008 06:49:17 -0700 (PDT)

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.

STARTUP FORCE
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?.

regards.

Fabio Zanotti.
.

Follow-Ups:
- Re: how to recover the DB from a dmp file?
  - From: DA Morgan
- Re: how to recover the DB from a dmp file?
  - From: Mark D Powell

Prev by Date: Re: Tree walking ordering at top of tree
Next by Date: Re: Choosing a surrogate key vs. a composite key - "holy war" issue or clear best practice?
Previous by thread: ORA-00959: tablespace '_$deleted$8$0' does not exist
Next by thread: Re: how to recover the DB from a dmp file?
Index(es):
- Date
- Thread