Re: how to recover the DB from a dmp file?
Date: Tue, 1 Jul 2008 07:23:45 -0700 (PDT)
On Jun 30, 3:49 pm, Fabio Zanotti <zanotti.fa..._at_gmail.com> wrote:
> 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?.
> Fabio Zanotti.
ORA-01110: data file 5: '/opt/oracle/oradata/st0918bo/indx01.dbf'
plz. help me, how to recover the DB from a dmp file ?
seems this is just an index file? Ofline and drop it?
H Received on Tue Jul 01 2008 - 09:23:45 CDT