Re: Recovery keeps asking for more logfiles

Hi,

This sounds like you're tablespaces are still in backup mode. when in mount stage, issue the following sql to check whether they still are:

select file#, status from v$backup;

if they still are in backup mode, they are listed as active.

Start by taking them out of backup mode, and run you're recovery. This should get you up and running normally.

Regards,
Morten Egan

Foggy wrote:
> Hi guru's,
>
> i have a recovery problem, maybe (hopefully ;) ) you have a solution.
>
> Here's the scenario:
>
> Hot backup of production server is made at night (from 3 AM till 4
> AM). When I try to restore this backup to another server (in the same
> network) on the next day (say 2 PM), Oracle uses all archived logfiles
> from the production server, and asks for the next archived logfile
> (that has not been archived yet).
>
> Why does Oracle keep on asking for archived log files, and doesn't
> stop when the archived log files from about 4 AM have been applied?
>
> Oracle 8.0.5 EE on WinNT 4.0 SP5
  Received on Thu Sep 12 2002 - 07:42:33 CDT