Shulou(Shulou.com)06/01 Report--

1. Database version

Oralce 12c 12.1.0.2

When the FRA runs out of space, the database automatically closes the flashback. The instance will not down. This BUG has been solved.

* * 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 cannot allocate new log 08 cannot allocate new log 29.735000 + 08:00Thread 1, sequence 132Checkpoint not complete

2. There is a bug in Oracle version 11.2.

Database instance will drop 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. This BUG official document

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.