Database terminated by RVWR process when FRA becomes full (Doc ID 1533577.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 

Alert log:

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

 
Call Stack from <sid>_rvwr_13323.trc:

ksedsts()+461<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+53<-ksuitm()+1325<-ksbrdp()+3344<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start_main()+244<-_start()+36

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms