You will need a copy of the controlfile that was created from 'alter
database backup controlfile to '<BackupControlFilename>'. This will be
copied as the controlfile(s) for the database to be recovered. So that
recovery could be performed as 'recover database using backup controlfile
until cancel'. If you do not have such a 'backup controlfile' then I do not
know how you can recover the DB on a different server with all the files you
have got.

Also, it would be a very good idea to buy 'Backup and Recovery Handbook' by
Rama Velpuri published by Oracle Press. It has all kinds of examples dealing
with various recovery scenarios.

HTH,

Regards.

- Kirti Deshpande
Verizon Information Services
http://www.superpages.com

> -----Original Message-----
> From: DBA GURUS [SMTP:[Email Address Removed] Sent: Tuesday, July 31, 2001 12:36 PM
> To: LazyDBA.com Discussion
> Subject: 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