If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

1. create new database using dbca on the same database server version.
2. create control file script as above.
3. Move new data files to some other place and copy old data files of your database on the new server.
4. Modify control file script so that it points to copied data files (Add all data files path).
5. now create new control file with the modified control file script.
6. Recover your database.(see database recovery process).

Hi, your post is something new to me and helpful. Anyway, upon a thorough search about the topic , I found out that the first control files of an oracle database are created when you issue the create database statement. On the other side, we are able to manually create a new control file for a database using the create control file statement. This is the reason why control file is recreated. I just hope, I make sense with this