Thursday , September 29 2022

How To Resize Redo Log Files In Oracle

In this article, I will talk about how to resize redo log files in Oracle.

1. We list the redo logs.

2. Currently redolog sizes are 50MB. In order to increase the redolog size to 100MB, we first drop the INACTIVE groups.

3. We also delete the Redo Log files through the operating system.

4. After the INACTIVE groups are dropped, we list them again.

5. We increase the size of the dropped redo log files to 100MB.

It is listed again.

6. We make a log switch to activate the groups in UNUSED state.

Melek Durdu
Author: Melek Durdu

About Melek Durdu

Leave a Reply

Your email address will not be published. Required fields are marked *