Archive Full Don’t Report Error On 12c

Last Friday I had a problem with a database, it is a little strange, a archive disk get full and run of free space but not error was reported. In this case the ora-00257 is always expected but no here, I don’t sure if it’s a new way of work on this release or any other condition interfered in the problem.

Below post the alert.log error, but when new connections to the database were performed any error was prompt, the connection only get hanged.

 

 
Unable to create archive log file '/oracle/financial/arch/FPROD_919411454_1_730.ARC'
Fri Oct 07 12:06:57 2016
Errors in file /oracle/diag/rdbms/fprod/fprod/trace/fprod_arc3_1984.trc:
ORA-19504: failed to create file "/oracle/financial/arch/FPROD_919411454_1_730.ARC"
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
ARC3: Error 19504 Creating archive log file to '/oracle/financial/arch/FPROD_919411454_1_730.ARC'
Fri Oct 07 12:06:57 2016
Unable to create archive log file '/oracle/financial/arch/FPROD_919411454_1_730.ARC' 

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s