RECOVER DATABASE, RECOVER gave ORA-01547

[dbabti]

Hi,
i'm triying to create a 10g database copy from another one in the same machine.. so this is what i done:

1- i stop the database source and copy the directories used by the database source (redo , ctl,index..)
2-i restart the database source and erase the ctl files from the new database directories.
3-i ran :
sqlplus "/ as sysdba"
create database backup controlefile to trace ;

4-i delete the cdump,bdump, udump files from the new database directory.

5- i open the latest version of the trc file under udump of the database source and use the paragraph Set#2 . RESETLOGS until the end of the trc file ,to create the new database.
so in this step , i used :

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "R11110" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 584
LOGFILE
GROUP 1 (
'/data01/oracle/r11110/redo1/redo1a.log',
'/index01/oracle/r11110/redo2/redo1b.log'
) SIZE 50M,
GROUP 2 (
'/data01/oracle/r11110/redo1/redo2a.log',
'/index01/oracle/r11110/redo2/redo2b.log'
) SIZE 50M,
GROUP 3 (
'/data01/oracle/r11110/redo1/redo3a.log',
'/index01/oracle/r11110/redo2/redo3b.log'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/data01/oracle/r11110/data/SYSTEM01.dbf',
'/data01/oracle/r11110/data/UNDO01.dbf',
'/data01/oracle/r11110/data/SYSAUX01.dbf',
'/data01/oracle/r11110/data/tbsfauser.dbf',
'/data01/oracle/r11110/data/tbsfamsg.dbf',
'/data01/oracle/r11110/data/tbsfauser1_1.dbf',
'/data01/oracle/r11110/data/tbsfauser2_1.dbf',
'/data01/oracle/r11110/data/tbsfauser3_1.dbf',
'/data01/oracle/r11110/data/tbsfauser4_1.dbf',
'/index01/oracle/r11110/index/tbsfaindx1_1.dbf',
'/index01/oracle/r11110/index/tbsfaindx2_1.dbf',
'/index01/oracle/r11110/index/tbsfaindx3_1.dbf',
'/index01/oracle/r11110/index/tbsfaindx4_1.dbf',
'/data01/oracle/r11110/data/tbsfaref.dbf',
'/index01/oracle/r11110/index/tbsfaref.dbf',
'/index01/oracle/r11110/index/tbsfvindx1_1.dbf',
'/data01/oracle/r11110/data/tbsfvuser1_1.dbf'
CHARACTER SET WE8ISO8859P15
;

the controlefile was created successfully

and then i tried :

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 7866782806751 generated at 07/12/2010 19:39:23 needed for thread 1
ORA-00289: suggestion : /moteurs/oracle/r11110/R11110/archivelog/2010_07_13/o1_mf_1_1158_%u_.arc
ORA-00280: change 7866782806751 for thread 1 is in sequence #1158


Specify log: {=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: '/data01/oracle/r11110/data/SYSTEM01.dbf'

and then the command: ALTER DATABASE OPEN RESETLOGS; dose'nt work..

Thanks for your help

[LKBrwn_DBA]

Copy the archive logs from the source database starting with o1_mf_1_1158_%u_.arc into the /moteurs/oracle/r11110/R11110/archivelog/2010_07_13 directory and try the recover again.