Re: Select a older Redlogfile

Stefan Fallet wrote:
>
> My most recent LOGFILE can't be read anymore. Do to the fact, that the
> tapedrive is damaged, we do not hace any backup files. How can we
> specify the previous logfile.
>
> If I do a
> recover database using backup controlfile;
>
> I am asked to specify a certain Redlog with Number X. This file can not
> be read. Ho do I specify the Redolog with X-1.
>
> Need Help fast
>
> Thanks
>
> Stefan Fallet
>
> stfallet_at_fallet.com

The only way to do this is to restore one or more datafiles from a backup, and do a recovery database using backup control file until cancel (redo n-1). Since you can't restore, you're (in my opinion) stuck.

I strongly suggest you contact Oracle Support for a second opinion before you attempt anything.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.