ORA-38760: This database instance failed to turn on flashback database-Toy模板网

这篇具有很好参考价值的文章主要介绍了ORA-38760: This database instance failed to turn on flashback database。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

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

ORA-38760: This database instance failed to turn on flashback database,OracleDB,数据库,oracle

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;文章来源地址https://www.toymoban.com/news/detail-615707.html

到了这里，关于ORA-38760: This database instance failed to turn on flashback database的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！