Re: Database crash

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Sat, 23 Oct 1999 14:40:22 +0200
Message-ID: <3811ACB6.8E33CC0E@wxs.nl>

> 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/> Received on Sat Oct 23 1999 - 07:40:22 CDT