您好,登錄后才能下訂單哦!
1、數據庫版本
Oralce 12c 12.1.0.2
當遇到FRA空間耗盡的時候,數據庫會自動關閉閃回。實例不會down掉。這個BUG已經解決掉了。
*************************************************************
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
數據庫實例會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)
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。