Re: Database crash

From: <akkha_at_my-deja.com>
Date: Sat, 23 Oct 1999 17:09:32 GMT
Message-ID: <7usq4b$tiv$1@nnrp1.deja.com>

Dear Erwin,

It works. Thanks a lot.

Anthony

In article <3811ACB6.8E33CC0E_at_wxs.nl>,
Erwin Dondorp <erwindon_at_wxs.nl> wrote:
> > I have got a database fully backed up (cold backup).
> > When I tried to recover from it, I got following
> > error messages:
> > ORA-00322: log 15 of thread 1 is not current copy
> > RA-00312: online log 15 thread 1:

'/ora03/oradata/TEMS/redoTEMS15.log'
> > How should I proceed?
>
> Did you restore this online redo log file as well?
>
> If NO: this is a logfile is from the earlier instance and it cannot be
> used with the restored database.
> do: SHUTDOWN, Remove the online redologfiles, STARTUP MOUNT, RECOVER
> DATABASE UNTIL CANCEL, ALTER DATABASE OPEN RESETLOGS
> The last statement will create fresh online redo logfiles.
> The recovery is needed to mark the database as recovered since only
then
> will RESETLOGS be allowed. If the database
> is consistent (should be for a cold backup) this statement doesn't do
> much.
>
> If YES: sorry, can't help you here.
>
> Erwin
> --
> Erwin Dondorp
> <http://www.dondorp.com/>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 23 1999 - 12:09:32 CDT