12c Cannot Start Database Due to Flashback Enabled

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

1、删除闪回日志

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

2、启动数据库

SYS@orcl1> startupORACLE instance started.Total System Global Area 1241513984 bytesFixed Size                  2923872 bytesVariable Size             620757664 bytesDatabase Buffers          603979776 bytesRedo Buffers               13852672 bytesDatabase mounted.ORA-38760: This database instance failed to turn on flashback database3、日志报错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.964637901ORA-15012: ASM file '+DATADG/ORCL/FLASHBACK/log_2.376.964637901' does not existDatabase mounted in Shared Mode (CLUSTER_DATABASE=TRUE)Lost write protection disabledCompleted: ALTER DATABASE   MOUNTALTER DATABASE OPENErrors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_10324.trc:ORA-38760: This database instance failed to turn on flashback databaseORA-38760 signalled during: ALTER DATABASE OPEN...2018-01-06 07:57:34.698000 +08:00Decreasing 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 bytesFixed Size                  2923872 bytesVariable Size             620757664 bytesDatabase Buffers          603979776 bytesRedo Buffers               13852672 bytesDatabase 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------------------YESSYS@orcl1> 

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