database cloning

I am trying to clone our production database to the was it was two weeks ago on a different machine using full backup copy from tape. These are the steps I have taken:

1- Made a backup copy of the control file from the production system, edited the file and renamed it with a .sql extension and moved it to the target machine.
2- Copied all the datafiles, redologs,control file, and archived logs that required from tape to the appropraited destination on the target machine.
3- copied the init.ora file from the production to the target machine.

Now this is where it gets funcky:

Started server manager then issued
connect internal
startup no mount
@ctrl.sql - to create control file

So far no problem.

I need to do media recovery, so I issued

recover database using backup controlfile until cancel

It start recovery using the archived logs and when it gets to the end of the list, it asks for more! It asks for the next one in the sequence. This is the point where I want to stop. So what command do I issue?

When I apply "recover database cancel", it complains

When I apply alter database open resetlogs; it complains.

What is the best way to restore this database, the way it was two weeks ago?

Thanks.

Jake Received on Thu Mar 13 2003 - 13:00:35 CST