Hi,

1. Restore the hotbackup file to the new server.
2. Use the output of "alter datbase backup controlfile to trace" and modify
to generate valid controlfile for the new location.
3. Create the controlfile.
4. Restore the archivelogs or later as prompted.
5. recover database using backup controlfile (it will use the controlfile u
created in step 3)
6. Last Alter database open reset logs.

Let me know you get stuck anywhere.

Alok
> -----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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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