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: Creating a controlfile - language needed?

Re: Creating a controlfile - language needed?

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 04 Oct 2005 08:22:52 -0700
Message-ID: <43429E4C.9040603@pacbell.net>


Goulet, Dick wrote:

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

Not exactly. If instance recovery is required, it is the online redo log files that you will need, not the original control file.

>
> 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.
>

Why create a new controlfile and open resetlogs when you don't need to?   Shutdown the database, copy all the files to the new locations, startup nomount, then use a series of ALTER DATABASE RENAME FILE commands to update the location of datafiles and online log files. Then create/drop tempfiles as appropriate. You still have to do the same amount of text file editing in either case.

In fact, you might even get away with simply using DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters.

-- 
Mark Bole
http://www.bincomputing.com



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 04 2005 - 10:26:08 CDT

Original text of this message

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