下午做过单表恢复,
recover table user.table_name until time "to_date('2018-12-21 15:00:00','yyyy-mm-dd hh24:mi:ss')" auxiliary destination '/backup/bak' remap table 'USER'.'TABLE_NAME':'USER'.'TABLE_NEW_NAME';
报错如下:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/21/2016 16:53:37
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command
解决方案:
configure default device type to SBT;
原因说明:
参考文档doc2105325.1
意思呢就是对于SBT格式的备份,使用recover table这个命令时候,不能手工分配channel,需要进rman里面人为配置一下。