This restore is from PROD to DEV. I could be wrong on my steps. After I copy over the datafiles, and delete the control files. I have not started the OracleService for the db. In NT4.0 we always had an OracleStartDB and an OracleServiceDB, 2000 only has the oracleservice. In the past I have always started the oracleservice but not the oraclestart. Thats the problem I get an Oracle not available error in SVRMGRL. If I start the oracleservice, when I get to the alter database open resetlogs step it errors with the datafile needs more recovery.

Hopefully this helps. If you can help I will answer questions all day long



Thanks