Re: Recovery keeps asking for more logfiles

From: KidRac <REMOVEmeUPPER_at_CASEkidracLETTERS.com>
Date: Thu, 12 Sep 2002 14:47:42 +0200
Message-ID: <3D808CEE.7010702@CASEkidracLETTERS.com>

First always check for the status in v$backup. There is no point in opening the database with resetlogs (and by that invalidating earlier backups), if you simply can take the datafiles out of backup mode, and continue normally.

-KidRac

Jake wrote:

> 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:47:42 CDT