OCP CBT Question 692

Please solve the following question.

You observe that your database's redo log files are filling up very quickly, leading to frequent log switches and a high volume of archived redo log files. This is impacting backup performance and storage. What is the most effective way to mitigate this issue without compromising recoverability significantly?

Online redo log files record all changes made to the database. When a log file fills, a log switch occurs, and the filled log file is then archived (if in ARCHIVELOG mode). Frequent log switches can lead to I/O contention and generate a large number of archived redo logs, impacting recovery processes and storage.

Increase the number of online redo log groups.

Disable ARCHIVELOG mode temporarily during peak load.

Increase the size of the online redo log files.

Configure RMAN to delete archived redo logs immediately after backup.