Re: Create controlfile syntax

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_at_hotmail.com>:
> 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/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l