ORA-38760: This database instance failed to turn on flashback database

早晨接一个任务，使用rman备份在虚拟化单机上恢复实例，恢复参数文件、控制文件和数据文件都正常，recover归档时报错如下：

Starting recover at 2023-07-28 10:25:01
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/28/2023 10:25:03
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until time 'JUL 23 2023 02:02:02' using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database

RMAN>

查看mos文档：RMAN Backup Based Duplicate using Standby Source fails with ORA-38760 (Doc ID 2880566.1)

处理办法：在mount状态下先关闭flashback

SYS@orcl> select name,flashback_on from v$database;

NAME                   FLASHBACK_ON
------------------ ------------------------------------
ORCL                   YES

SYS@orcl>   alter database flashback off;

Database altered.

SYS@orcl> select name,flashback_on from v$database;

NAME                   FLASHBACK_ON
------------------ ------------------------------------
ORCL                   NO

关闭重新执行归档应用

RMAN> recover database delete archivelog;