Re: how to recover the DB from a dmp file?

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?.
>
> regards.
>
> 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