Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> db copy from prd to dev
Hi, i am copying my oracle 8.1.7 from PRD 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