温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

12c Cannot Start Database Due to Flashback Enabled

发布时间:2020-04-09 04:12:22 来源:网络 阅读:679 作者:roidba 栏目:关系型数据库

模拟故障场景
删除所有闪回日志,重启数据库实例

1、删除闪回日志

ASMCMD [+datadg/orcl] > cd flashback
ASMCMD [+datadg/orcl/flashback] > ls
log_1.377.964637895
log_2.376.964637901
log_3.374.964648865
ASMCMD [+datadg/orcl/flashback] > rm log_*
ASMCMD [+datadg/orcl/flashback] > 

2、启动数据库

SYS@orcl1> startup
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  2923872 bytes
Variable Size             620757664 bytes
Database Buffers          603979776 bytes
Redo Buffers               13852672 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database

3、日志报错
SYS@orcl1> 
RVWR started with pid=40, OS id=10323 
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_rvwr_10323.trc:
ORA-38701: Flashback database log 2 seq 2 thread 1: "+DATADG/ORCL/FLASHBACK/log_2.376.964637901"
ORA-17503: ksfdopn:2 Failed to open file +DATADG/ORCL/FLASHBACK/log_2.376.964637901
ORA-15012: ASM file '+DATADG/ORCL/FLASHBACK/log_2.376.964637901' does not exist
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
ALTER DATABASE OPEN
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_10324.trc:
ORA-38760: This database instance failed to turn on flashback database
ORA-38760 signalled during: ALTER DATABASE OPEN...
2018-01-06 07:57:34.698000 +08:00
Decreasing number of real time LMS from 1 to 0

4、解决方法

SYS@orcl1> 
SYS@orcl1> alter database flashback off;

Database altered.

SYS@orcl1> alter database open;

Database altered.

SYS@orcl1> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl1> startup mount;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  2923872 bytes
Variable Size             620757664 bytes
Database Buffers          603979776 bytes
Redo Buffers               13852672 bytes
Database mounted.
SYS@orcl1> alter database flashback on;

Database altered.

SYS@orcl1> alter database open;

Database altered.

SYS@orcl1> select flashback_on from v$database;

FLASHBACK_ON
------------------
YES

SYS@orcl1> 

5、官方文档号
(文档 ID 274569.1)

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI