Re: Creating a controlfile - language needed?
- From: Mark Bole <makbo@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 04 Oct 2005 08:22:52 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
