How to resize REDO LOGS
The redo logs record all changes that occurred to the data. Every DB has at least two redo log files because Oracle writes these files in a circular fashion: when a redo log file is full then Oracle writes in the next, when the last redo log file is full then Oracle restarts from the first but making sure to store information in the data file before you overwrite them. If any anomaly does not allow writing of the changes that occurred to the database in their data file, then we can safely get those changes from the redo log...