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