I believe you should startup mount your database and if the lost log
was archived, issue the ALTER DATABASE CLEAR LOGFILE command. If the lost
log was unarchived, issue the ALTER DATABASE CLEAR UNARCHIVED LOGFILE
command. Then you open resetlogs. Save a copy of your backup first, in case
this doesn't work.

HTH,
Patricia.

> ----- Mensagem original -----
> De: DBA GURUS [SMTP:[Email Address Removed] Enviada em: Terça-feira, 31 de Julho de 2001 14:36
> Para: LazyDBA.com Discussion
> Assunto: recover database
>
> Say I have complete hotbackup copies of all data files and archived log
> files. And Control file has been obtained from the statement 'Alter
> datbase
> backup controlfile to trace;'. Now I do not have any redo log files, how
> can
> I restore and recover the DB to a different server?
>
> Thanks
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page