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

Or rather, does 'select * from v$backup' indicate *any* active datafiles (fixing up datafile 1 might not fix the entire problem).

Incidentally, I always teach that anytime you get a 'file X needs media recovery' message, you immediate query both v$backup and v$recover_file. A habit worth getting into.

Regards
HJR "Juhan Kundla" <juhan_at_ensib.NICHT-SPAM.ee> wrote in message news:3A880344.F7313117_at_ensib.NICHT-SPAM.ee...
> 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 |
> +-----------------+
Received on Tue Feb 13 2001 - 01:31:07 CST