Online redo log files are files that hold transaction records in the database. Log files to recover the database in case of a problem. For example, if we shut down the database abruptly (shutdown abort), SMON performs instance recovery by reading these log files during database startup. There must be at least two online redo log … Continue reading Managing Online Redo Log Files