Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Create controlfile syntax

Re: Create controlfile syntax

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Tue, 15 Nov 2005 19:42:18 +0100
Message-ID: <c2213f680511151042g6f55296dx@mail.gmail.com>


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
Received on Tue Nov 15 2005 - 12:44:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US