Oracle archive log destination filled up to 100% for Clarity

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Oracle Archive Redo logs are filling up the disk 100%, Clarity would generate a lot more Archive Logs, and there is no more space left in the folder which causes the entire database server to freeze

Environment

Release : Any

Resolution

• The issue you are facing is not a Clarity but an Oracle issue. It has to do with Oracle Redo Archive log space and the database configuration. The DBA should be engaged to assist you.
• Here are few pointers on how to work on Log archive destination full issues:
  • http://www.dba-oracle.com/t_archived_redo_log_directory_full.htm
  • http://www.dba-oracle.com/concepts/archivelog_archived_redo_logs.htm
  • https://developpaper.com/solve-the-problem-of-oracle-database-archive-log-occupying-full-disk-space/
• There is the option of deleting some of the files, ensuring the DB config is correct etc.
• One quick thing you can do is to add storage. Alternatively you may want to raise a case with Oracle Support to assist.
• The reason why this works well on one environment and not another may be because some database parameters are different such as db_recovery_file_dest_size, or how the archiving is set up. 

Additional Information

Question: Why is the Oracle Archive logs directory filling up overnight with no Clarity application usage? 
This could be explained by processes or scheduled jobs, it is typical for Clarity application to be running scheduled jobs or processes which can account for large amounts of transactions. This happens without any user activity. Note Clarity is an application able to handle high volume of SQL transactions from user activity/jobs/processes.