Archivelog * SOLVED*

From: Weerd de E.C. Kirsten <Kirsten.deWeerd_at_Oranjewoud.nl>
Date: Tue, 6 Jun 2000 16:12:08 +0100
Message-Id: <10520.107873@fatcity.com>

Ok ALL,

Problem solved. Thanx for all the help.

Trying to give a short sesume :

Archive Log Destination dir was empty : Files had been automatically moved (Cron-job or something like that) No new logswitch occured, so no new archived log file.

Recovery asked for log newer than the last existing : We were recovering into a secondary test-system. We did not use the controlfiles from the original production-system. Oracle then apparently looks for the last known log file + 1 (Which we didn't have)
Solution : USING BACKUP CONTROLFILE

So, final statement which did the trick and got the DB running without problems :

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL Thanx all for sharing U'r knowledge.

Can't even remember how many times this list helped me out !!! Received on Tue Jun 06 2000 - 10:12:08 CDT