How can I copy db files to another server with different drive configuration?
I need to copy my production 10g server to a test 10g server.
Under 8i, I was able to accomplish this by:
1) copying the physical datafiles to the test server
2) create a trace file from the production server control file
3) modify the trace file from step 2 to point to the correct file locations
4) save the trace file as a sql file
5) run the sql file to startup the test server.
The test server then came up essentially like the production server.
Under 10g, I am unable to accomplish the same thing. The above steps cause the test server to come up pointing to the instance on the production server.
Under 8i, I was able to accomplish this by:
1) copying the physical datafiles to the test server
2) create a trace file from the production server control file
3) modify the trace file from step 2 to point to the correct file locations
4) save the trace file as a sql file
5) run the sql file to startup the test server.
The test server then came up essentially like the production server.
Under 10g, I am unable to accomplish the same thing. The above steps cause the test server to come up pointing to the instance on the production server.
0