Joël Cattin has more than seven years of experience in database management, specializing in Oracle solutions including Data Guard, RMAN, Oracle Database Appliance (ODA), Real Application Clusters (RAC), and APEX development, alongside PostgreSQL and MySQL. He is also experienced with AWS cloud solutions and Ansible-based IT automation. He holds Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server Certified Professional, RedHat Certified System Administrator, and ITIL V3 Foundation certifications, and leads three InSite Workshops (Oracle Basics, Linux for DBAs, and Ansible). He holds a degree from ESIG Delémont.
We discovered a strange behavior in the Alert Log when the Fast Recovery Area (FRA) is full and the database wants to write something inside it (for example an archivelog). This case concern Oracle 11.2.0.3 databases and higher. Here is a demo with a 12c database (12.1.0.2) : First, to reproduce the behavior, I set a very small size to the FRA :…
