Hi everybody,
i need help how to clone (recover) our prod database to another server from disk (tape). Our prod database is in RAC with ASM and I need to clone it to different server without ASM and RAC. Everything is Win2003 Srv.
I do it this way:

1. On prod server i make backup running this script in RMAN
configure channel device type 'SBT_TAPE' parms'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=e:\backup)';

RUN {
backup device type SBT_TAPE database tag zal20081129;
SQL 'alter system archive log current';
backup device type SBT_TAPE archivelog ALL tag zal20081129;
}

2. I prepared clon instance on another server (The same Oracle version) and start it to nomount mode.

3. I copied the backup from prod server to clon server to exactly the same path. (e:\backup)

4. On clon server i connect to RMAN
set ORACLE_SID=clon
rman
connect target /

set DBID 3079749916 - that is DBID from our prod DB

startup nomount;

run {
allocate CHANNEL CTAPE DEVICE TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=e:\backup)';
allocate channel CDISK DEVICE TYPE DISK;
restore controlfile from 'e:\backup\name_of_backup_file'; -this restore control file correctly
}

alter database mount;

run {
Set newname for datafile 1 to 'e:\oradata\CLON\system.272.668509367';
Set newname for datafile 2 to 'e:\oradata\CLON\undotbs1.273.668509387';
Set newname for datafile 3 to 'e:\oradata\CLON\sysaux.263.668509393';
Set newname for datafile 4 to 'e:\oradata\CLON\ifsapp_archive_data.298.668509401';
Set newname for datafile 5 to 'e:\oradata\CLON\ifsapp_archive_index.258.668509401';

restore database;

switch datafile all;

recover database;
}

But i got this error
.....
....
filename=E:\ORADATA\AGOST\IFSAPP_INDEX.299.668510843
datafile 16 switched to datafile copy
input datafile copy recid=84 stamp=672939884 filename=E:\ORADATA\AGOST\IFSAPP_DATA.300.668510859
datafile 17 switched to datafile copy
input datafile copy recid=85 stamp=672939884 filename=E:\ORADATA\AGOST\IFSAPP_DATA.301.668510865

Starting recover at 08-DEC-08
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1

starting media recovery

Oracle Error:
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: 'E:\ORADATA\AGOST\SYSTEM.272.668509367'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/08/2008 15:45:14
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 227 lowscn 800414116 found to restore


Shall i set any SET UNTIL clause???? or what is wrong. Why Oracle doesnt recover just to the point of the backup saved in e:\backup?
please help
John