Error Message

备份作业有如下报错信息

最终错误: 0xe0000340 - 数据库脚本返回一个错误。  详细信息，请参见数据库脚本输出一节。
最终出错类别: 资源出错

RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
RMAN-03002: failure of restore command at 03/02/2022 19:36:42 
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

在 RMAN 会话中运行 'show all;'命令并检查 AUTOBACKUP 设置
AUTOBACKUP 设置应如下所示：
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; 
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%d_%I_%F';

在客户的“目标服务器”环境中，AUTOBACKUP 设置丢失

Oracle DBA 添加 RMAN AUTOBACKUP 配置设置：
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; 
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%d_%I_%F';

Related Articles:

When trying to restore Oracle controlfile, RMAN reports "RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece"