I was managing an environment where we needed to investigate the redo log switch frequency in our environment due to some graph spikes visualized using Grafana dashboards. A simple SELECT command using the view V$LOG_HISTORY is required to accomplish this goal. Therefore, below is presented this SQL SELECT command and the output: I hope this post helps you! brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech…
Day: April 17, 2023
Archive log not deleting within retention policy
I was managing an ORACLE RAC database configured with Oracle Data Guard when I discovered the archive log was not being deleted after the retention policy of 2 days in our backup configuration. Therefore, I started the investigation by collecting some information from the alert log. And the first initiative I took was to verify if the database had been deleting old archives when there was a space pressure in the recovery area as below: It is a cheerful and ordinary Oracle database approach to automatically deleting unneeded files. The…