RE: Creating a controlfile - language needed?

Depends.  Was the database shutdown cleanly before you rebuilt the
control file?  If not then you need it. 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Tuesday, October 04, 2005 9:39 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Creating a controlfile - language needed?

When creating a controlfile from a trace file, is this wording simply 
removed or altered:

RECOVER DATABASE

ALTER SYSTEM ARCHIVE LOG ALL;

I have changed the other info to read
"CREATE CONTROLFILE REUSE DATABASE "SID_NAME" RESETLOGS NOARCHIVELOG"
At the very bottom of the script I have changed it to read
"ALTER DATABASE OPEN RESETLOGS"

I am copying a database to a new server and all of the 200+ files will
have 
a new directory structure (but will keep the same SID) so that is why I
am 
creating a new controlfile.

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: