how to recover the DB from a dmp file?
Date: Mon, 30 Jun 2008 06:49:17 -0700 (PDT)
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 bytesDatabase 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