Re: Create controlfile syntax

  • From: Alex Gorbachev <gorbyx@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Tue, 15 Nov 2005 19:42:18 +0100

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


Other related posts: