温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

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

发布时间:2020-05-21 16:38:16 来源:亿速云 阅读:463 作者:鸽子 栏目:关系型数据库

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)

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI