Re: when database startup, error...??

Maybe, just maybe, your datafiles were in backup mode, when you shut down your db instance. Before you start recovering, try what 'alter datafile 1 end backup' does. Does this solve your problem?

Cheers,
Juhan

jenny wrote:
>
> 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.
 

-- 
+-----------------+
|NB! Please remove|
|   .NICHT-SPAM   |
|  when replying  |
|    to get my    |
|     *REAL*      |
| e-mail address! |
|                 |
|  Cheers, Juhan  |
+-----------------+