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

最新推荐文章于 2021-07-27 14:47:49 发布

转载最新推荐文章于 2021-07-27 14:47:49 发布 · 132 阅读

文章标签：

#数据库

本文介绍了解决ORA-38760错误的方法。该错误通常发生在尝试打开数据库时，由于Flashback信息不完整导致。文章提供了两种解决方案：关闭Flashback功能再打开数据库或直接关闭数据库后重新启动。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

问题背景:
測试数据库运行shutdown immediate，日志里面报错，错误信息为：ORA-19815: WARNING: db_recovery_file_dest_size of 4322230272 bytes is 99.77% used, and has 9814016 remaining bytes available.
随即我运行startup force mount将数据库强制关闭并启动到mount状态，通过RMAN把历史备份和归档信息都删除后启动数据库报错ORA-38760.

问题现象：

SQL> startup mount;
ORACLE instance started.

Total System Global Area 2872786944 bytes
Fixed Size                  2256712 bytes
Variable Size            2634023096 bytes
Database Buffers          218103808 bytes
Redo Buffers               18403328 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database

问题分析：
该错误通过查看Metalink 后得知是由于Flash back信息不完整导致。

[oracle@db01 ~]$ oerr or 38760
oerr: Unknown facility 'or'
[oracle@db01 ~]$ oerr ora 38760
38760, 00000, "This database instance failed to turn on flashback database"
// *Cause: Database flashback is on but this instance failed to
//         start generating flashback data. Look in alert log for more
//         specific errors.
// *Action: Correct the error or turn off database flashback.

解决的方法：

#1、关闭flash backup再open database
SQL> alter database flashback off;
SQL> alter database open;

#2、第二种办法直接关闭数据库后再启动也是能够的
SQL> startup force mount;
ORACLE instance started.

Total System Global Area 2872786944 bytes
Fixed Size                  2256712 bytes
Variable Size            2634023096 bytes
Database Buffers          218103808 bytes
Redo Buffers               18403328 bytes
Database mounted.

SQL> alter database open;

Database altered.
SQL>