We cold copied all datafiles from out old server to our new one. However, the datafiles sit in a different directory structure
We are going to run the "create controlfile" to re-identify to locations of the datafiles (from /oradata to /u01/POSPROD/dbf).
Can we then (after the control files are made and copied to the locations specified in the init.ora) simply startup the DB,
or must we statup mount, and do a "rename database datafile ... from the old to new locations?
I thought all we had to do was update the control file.. correct?
04-25-2002, 11:36 AM
You don't have to 'alter databae datafile ... rename...'
04-25-2002, 11:58 AM
ok, so recreating the control files is enough then?
04-25-2002, 12:07 PM
Yeh re-creating the control file is correct,
In the create control file statement make sure you have 'SET DATABASE' instead of reuse database.