Problem creating database copy from hot backup

I am trying to create a copy of a 8.1.7 production database to a test machine using hot backups. I do the following steps:

• On the source machine ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
• Run hot backup on production machine to tape
• Restore backed up files on tape to test server
• Create a script to create a new controlfile for the new database using the output from step 1. I modify the CREATE CONTROLFILE statement as follows and I strip out everything except the following:

	STARTUP NOMOUNT
	CREATE CONTROLFILE SET DATABASE "new_dbname" RESETLOGS NOARCHIVELOG
	    MAXLOGFILES 32
	    MAXLOGMEMBERS 2
	    MAXDATAFILES 33
	    MAXINSTANCES 8
	    MAXLOGHISTORY 908
	LOGFILE
	  ... List redo logs modified to reflect new locations on test server
	DATAFILE
	  ...List datafiles modified to reflect new locations on test server
	CHARACTER SET WE8ISO8859P1;
	

• Run the script from previous step on test server in SVRMGRL
• Recover the database with the following command:

        RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;         

• I successfully apply archived redo logs and when I get to the desired point I type CANCEL.

I have tried this at least a half dozen times on different databases and at this point I *always* get the same message in reference to the SYSTEM datafile:

  Specify log: {<RET>=suggested | filename | AUTO | CANCEL}   CANCEL
  ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
  ORA-01194: file 1 needs more recovery to be consistent   ORA-01110: data file 1: '/u5/oradata/tcedm/system01.dbf'         

Am I missing a step or doing something wrong here? Is it possible to create a copy of a database this way?

Any help would be greatly appreciated.

Thanks - Mike Received on Wed Feb 26 2003 - 11:37:48 CST