Hi,
trying to recover a table from tape backup on 12c database (dropped it accidently):
RMAN> run {
allocate channel ch1 type sbt;
allocate channel d1 type disk;
recover table kivang.NG_TEMP_GRC_4_7C until time "to_date('2017-05-02 01:00:00','yyyy-mm-dd hh24:mi:ss')" auxiliary destination '/opt/o61p/oracle/aux';
release channel ch1;
release channel d1;
}
But get this error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/05/2017 11:56:49
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command
Any ideas? Thanks.