Re: Need to change data file paths

You can create a new controlfile, using 'alter database backup controlfile to trace;'. Shut down the database normal or immediate. Copy the files to the new host in the directories you want. Edit the trace file that was generated by the backup command to indicate the new location of all the data files and place it on the new server. The trace file will have 'reuse database', change this to 'set database'. Change 'noresetlogs' to 'resetlogs'. You can delete all lines down to the 'create controlfile ...' statement, and all lines after the ';' after the datafile names. You can also change any parameters such as maxlogfiles, maxdatafiles to different numbers at this time. You can also change the size of redo logs, add or remove redo groups/members at this time. You can name the file anything, such as control.ctl

In svrmgr, enter 'startup nomount'
@control.ctl
alter database open resetlogs;

David Van Zandt wrote:

> Hi all, I need to migrate some 7.3.4 instances to a new host, and want
> to make them OFA-compliant. Aside from editing the initxx.ora, any
> suggestions on the best way to convert "bad" path names?
Received on Wed Oct 27 1999 - 14:26:17 CDT