Today we are going to work on the steps used for Resize the online Redo Logfiles.  Let’s follow the steps:- Single Instance:

1. First, see the size of the current logs:

2. Logs are 1MB from above, let’s size them to 10MB. Retrieve all the log member names for the groups:

3. Let’s create 3 new log groups and name them groups 4, 5, and 6, each 10MB in size:

4. Now run a query to view the v$log status:

From the above, we can see log group 2 is current, and this is one of the smaller groups we must drop. Therefore let’s switch out of this group into one of the newly created log groups.

5. Switch until we are into log group 4, so we can drop log groups 1, 2, and 3:

6. Run the query again to verify the current log group is group 4:

Note: redo log Group 1 or 2 or 3 can be active after “alter system switch log file” which means could not be dropped, in this case, you need to do “alter system checkpoint” to make redo log groups 1,2 and 3 inactive.

7. Now drop redo log groups 1, 2, and 3:

Verify the groups were dropped, and the new groups’ sizes are correct.

8. At this point, you consider taking a backup of the database. 9. You can now go out to the operating system and delete the files associated with redo log groups 1, 2, and 3 in step 2 above as they are no longer needed:

Today’s thought!

If we can let go of tension on all levels of our being we can move forwards very quickly. John Palmer, Easter Love

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.