db copy from prd to dev

Hi, i am copying my oracle 8.1.7 from PRD to DEV.

1. A offline restore from PRD to DEV, all data files.
2. In DEV, change the sid name to PRD in initDEV.ora
3. startup mount
4. change the control file sid to DEV
5. in initDEV.ora, change the sid name to DEV

i did a startup and get the below

SVRMGR> connect internal
Connected.
SVRMGR> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/oracle/SID/sapdata1/system_1/system.data1' SVRMGR> a little bit of background as below
1) PRD filesystem is /oracle/PRD/sapdata* where * is a number 2) in my DEV, the filesysetm is /oracle/DEV/sapdata*

therefore, i am restoring my PRD datafiles to my DEV with the paths not correct. This should be the problem. Basically, beside the change of SID in the initDEV.ora, all other oracle settings in DEV remain as they are for the DEV instance.

Any help with the above startup error? Received on Sun Oct 10 2004 - 09:40:56 CDT