解決數(shù)據(jù)庫Bug:RVWR TERMINATES INSTANCE IF FRA IS FULL

1、數(shù)據(jù)庫版本
Oralce 12c 12.1.0.2
當(dāng)遇到FRA空間耗盡的時候，數(shù)據(jù)庫會自動關(guān)閉閃回。實(shí)例不會down掉。這個BUG已經(jīng)解決掉了。

*************************************************************
WARNING: A file of type FLASH BACK may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result 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 +datadg
ORA-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 down
2018-01-06 09:08:29.735000 +08:00
Thread 1 cannot allocate new log, sequence 132
Checkpoint not complete

2、在Oracle 11.2版本中有一個bug
數(shù)據(jù)庫實(shí)例會down掉

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

3、這個BUG官方文檔
Database terminated by RVWR process when FRA becomes full (文檔 ID 1533577.1)