首页 > 代码库 > ORA-38760: This database instance failed to turn on flashback database
ORA-38760: This database instance failed to turn on flashback database
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>
ORA-38760: This database instance failed to turn on flashback database
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。