Deleting / Dropping a Redo Log File or a Redo Log Group
How to delete a Redo Log File or a Redo Log Group and Recreating a new one? What are the steps that need to be taken care during the whole Redo Log Deletion process?
Redo Log files are an important part of our Oracle Database as they collect all the entries for the changes made to the database. Usually we see 3 Redo Log Groups that are by default present in your system whenever you install the Oracle Database. Each log group contains a logfile which contains all the changed log information. If archive mode is enabled, the log from these Redo Log Files is copied to archive logs which are kept separated in Flash Recovery Area (By Default) or somewhere else ( Manually Defined Path), depending upon your need.
