List, I am in the middle of testing my backup procedures and have come across something that I'm stuck on. I've read through Velpuri's ver8 book and the Oracle docs but am still having difficulties. I need to restore an entire db from a hot backup, to another server. The above mentioned book and docs address restoring pieces/parts, but not the whole thing. I am backing up datafiles, archived log files and control file to file and trace. No online redo logs. 1. I restore datafiles and archived redo logs. 2. Edit init file, startup nomount 3. Create control file resetlogs (I tried the binary one too) 4. recover database until cancel using backup controlfile. It just keeps asking for log files. If I cancel and open with resetlogs its says my system file still needs media recovery. So, is a hot backup an appropriate means of recovering a database to another server? My cold backups are only every quarter, so rolling forward would be doable but tedious. Any ideas or suggestions? Thanks Joe
__________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Hatchel INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
