Re: Recovery keeps asking for more logfiles

From: Jake <me_at_heyjay.com>
Date: Thu, 12 Sep 2002 07:46:30 -0500
Message-ID: <alq27q$ghi$1@bob.news.rcn.net>

Type: cancel
then type: alter database open resetlogs

One other thing to remember, is when you're performing your backup, after you're done with all your datafiles, perform a log switch (to archive your current redo log) this way you get all the database changes that occurred (up till) during your backup.

Jake
"Foggy" <sjefke12_at_hotmail.com> wrote in message news:f78e018a.0209120418.8d54e13_at_posting.google.com...
> 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:46:30 CDT