TSPITR

Tablespace point time recovery:

run
{
recover tablespace users until time "to_date('13-oct-14 11:00:00','dd-mon-rr hh24:mi:ss')" auxiliary destination '/home/oracle/auxdest';
}


Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/13/2014 12:20:11
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command

workaround:

RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt parms='SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u05)';

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u05)';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete