重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-38760: This database instance failed to turn on flashback database [打印本页]

---

作者: jiawang    时间: 2020-8-18 09:57
标题: ORA-38760: This database instance failed to turn on flashback database
报错现象：
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信息不完整导致。

尝试关闭闪回
SQL> alter database flashback off;
Database altered.

再次打开数据库，依旧报错

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database


查看下闪回的状态
SQL>  select flashback_on from v$database;

FLASHBACK_ON
------------------
RESTORE POINT ONLY


SQL> select name from v$restore_point;

NAME
--------------------------------------------------------------------------------
UPDATE_RSP

SQL> drop restore point UPDATE_RSP;

Restore point dropped.

SQL> alter database flashback off;

Database altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO

SQL> alter database open;

Database altered.

SQL>

---

欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2