Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: when database startup, error...??
Performing media recovery would be a good first step... Have a look in v$recover_file and see what it has to say...
(The shortest answer I can give is to read the section on recovery in the
administrators guide!)
"jenny" <mjjung_at_gngidc.net> wrote in message
news:95vtgv$ohg$1_at_news2.an.gngidc.net...
> hi~ all.
>
> we installed Oracle 8.1.5 on solaris 2.7 for backing up test.
>
> when we do backing up via export utility, it appeared below error.
>
> ------------------------------------------------------------
> reserve:/export/home/oracle 51 $ exp system/manger
>
> Export: Release 8.1.5.0.0 - Production on Fri Feb 9 13:49:03 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> EXP-00056: ORACLE error 1033 encountered
> ORA-01033: ORACLE initialization or shutdown in progress
> EXP-00222:
> System error message 2
> Username:
> Password:
> XP-00222:
> System error message 10
> EXP-00005: all allowable logon attempts failed
> EXP-00000: Export terminated unsuccessfully
> ----------------------------------------------------------
> so after shutdown, we did startup database.
>
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 35052944 bytes
> Fixed Size 64912 bytes
> Variable Size 18030592 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 180224 bytes
> Database mounted.
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1:
'/export/home/oracle/DB/oradata/TEST01/system01.dbf'
>
>
>
> how to resolve above problem?
>
> thanks.
>
>
>
Received on Fri Feb 09 2001 - 08:32:33 CST