how to recover the DB from a dmp file?
From: Fabio Zanotti <zanotti.fabio_at_gmail.com>
Date: Mon, 30 Jun 2008 06:49:17 -0700 (PDT)
Message-ID: <9052f709-5eb4-487f-bdb8-ea6ce2c72bb2@59g2000hsb.googlegroups.com>
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/opt/oracle/oradata/st0918bo/indx01.dbf'
Date: Mon, 30 Jun 2008 06:49:17 -0700 (PDT)
Message-ID: <9052f709-5eb4-487f-bdb8-ea6ce2c72bb2@59g2000hsb.googlegroups.com>
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 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?.
regards.
Fabio Zanotti. Received on Mon Jun 30 2008 - 08:49:17 CDT