12c Cannot Start Database Due to Flashback Enabled

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

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)