解决数据库Bug:RVWR TERMINATES INSTANCE IF FRA IS FULL

1、数据库版本
Oralce 12c 12.1.0.2
当遇到FRA空间耗尽的时候，数据库会自动关闭闪回。实例不会down掉。这个BUG已经解决掉了。

*************************************************************WARNING: A file of type FLASH BACK may exist indb_recovery_file_dest that is not known to the database.Use the RMAN command CATALOG RECOVERY AREA to re-catalogany such files. If files cannot be cataloged, then manuallydelete them using OS command. This is most likely theresult of a crash during file creation.*************************************************************Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_rvwr_11005.trc:ORA-38886: WARNING: Flashback database was disabled due to error when writing flashback database logs.ORA-38701: Flashback database log 8 seq 8 thread 1: "+datadg"ORA-17502: ksfdcre:4 Failed to create file +datadgORA-15041: diskgroup "DATADG" space exhausted*************************************RVWR encountered an error when writing flashback database logs.See error stack in alert log.  To avoid crashing the instance,this instance has turned off flashback database.*************************************RVWR shutting down2018-01-06 09:08:29.735000 +08:00Thread 1 cannot allocate new log, sequence 132Checkpoint not complete

2、在Oracle 11.2版本中有一个bug
数据库实例会down掉

Reconfiguration completeFri Feb 01 15:06:35 2013Errors in file ...../_rvwr_13323.trc:ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.ORA-38701: Flashback database log 71 seq 837 thread 4: "+DEV_FBA"ORA-17502: ksfdcre:4 Failed to create file +DEV_FBAORA-15041: diskgroup "DEV_FBA" space exhausted*************************************************************WARNING: A file of type FLASH BACK may exist indb_recovery_file_dest that is not known to the database.Use the RMAN command CATALOG RECOVERY AREA to re-catalogany such files. If files cannot be cataloged, then manuallydelete them using OS command. This is most likely theresult of a crash during file creation.*************************************************************Errors in file ...../_rvwr_13323.trc:ORA-38701: Flashback database log 71 seq 837 thread 4: "+DEV_FBA"ORA-17502: ksfdcre:4 Failed to create file +DEV_FBAORA-15041: diskgroup "DEV_FBA" space exhaustedFri Feb 01 15:06:35 2013System state dump requested by (instance=4, osid=13323 (RVWR)), summary=[abnormal instance termination].System State dumped to trace file ...../_diag_12955.trcRVWR (ospid: 13323): terminating the instance due to error 38701 Fri Feb 01 15:06:36 2013opiodr aborting process unknown ospid (13159) as a result of ORA-1092Fri Feb 01 15:06:36 2013ORA-1092 : opitsk aborting processFri Feb 01 15:06:40 2013ORA-1092 : opitsk aborting processFri Feb 01 15:06:40 2013ORA-1092 : opitsk aborting processInstance terminated by RVWR, pid = 13323Fri Feb 01 15:06:52 2013Adjusting the default value of parameter parallel_max_servers

3、这个BUG官方文档
Database terminated by RVWR process when FRA becomes full (文档 ID 1533577.1)