If memory serves me correct: 1 STARTUP NOMOUNT 1. CREATE CONTROLFILE ... RESETLOGS... 2. (optionally) Add temp files 3. ALTER DATABASE MOUNT; 4. RECOVER DATABASE UNTIL CANCEL; 5. ALTER DATABASE OPEN RESETLOGS; The 4th one is needed because you can open database with resetlogs only from incomplete recovery. 2005/11/15, J. Dex <cemail_219@xxxxxxxxxxx>: > I have seen documentation saying different things so I was wondering if > someone could just verify this for me. When trying to restore a copy of a > database and give it a new name, in the create controlfile statement there > shouldn't be any reference to "RESTORE DATABASE"? Is that correct? > > My understanding is that the last line in the file should be "ALTER DATABASE > OPEN RESETLOGS". The first line should be CREATE CONTROLFILE SET DATABASE > "new_SID" RESETLOGS NOARCHIVELOG > > The restore was done from a clean shutdown immediate. > > Thanks. > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > //www.freelists.org/webpage/oracle-l > > > -- Best regards, Alex Gorbachev -- //www.freelists.org/webpage/oracle-l