RMAN TSPITR error

[patrick118]

I am trying to run a TSPITR but i get an error and not sure how to solve this.

RMAN> run
2> {recover tablespace VLAAR_DATA, VLAAR_DATA2, VLAAR_INDEX, VLAAR_INDEX2 until
time '28-MAR-2006 14:01:00' auxiliary destination 'c:\';}
Starting recover at 28-MAR=2006 14:38:16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=155 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=147 devtype=DISK
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified
point in time

List of tablespaces expected to have UNDO segments
tablespace SYSTEM
tablespace UNDOTBS1

contents of Memory Script:
{
# set the until clause
set until time "28-MAR-2006 14:01:00";
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# avoid unnecessary autobackups for structural changes during TSPITR
sql 'begin dbms_backup_restore.AutoBackupFlag(FALSE); end;';
}
executing Memory Script

executing command: SET until clause

Starting restore at 28-MAR=2006 14:38:23
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/28/2006 14:38:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command

RMAN> **end-of-file**

RMAN>

 

[patrick118]

found the answer i had to do the following in my RMAN script
run
{ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
recover tablespace VLAAR_DATA, VLAAR_DATA2, VLAAR_INDEX, VLAAR_INDEX2 until time '28-MAR-2006 14:01:00' auxiliary destination 'c:\';}

Now i find another problem. The tablespace are now before my last resetlogs and i can't get them online. But i want this copy to be online.

SQL> alter tablespace VLAAR_INDEX online;
alter tablespace VLAAR_INDEX online
*
ERROR at line 1:
ORA-01190: control file or data file 6 is from before the last RESETLOGS
ORA-01110: data file 6: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\VLAAR_INDEX.DBF'