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! brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped…
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…