How to resize redo log file in oracle 11g

Excellent Sir, thanks a lot for the article. Just a little contribution though. When you drop a logfile, you don't necessarily have to delete the file at the OS level.

You can add "reuse" to the syntax when recreating a logfile. Post a Comment. Saturday, November 26, How to resize redolog file in oracle. Once , i receive the e-mail regarding the resize of the redo log file. The Sender want the easiest way to size the redo log file something like 'alter database logfile group 1 '? We cannot resize the redo log files. We must drop the redolog file and recreate them.

You will have to set your redo log size high enough so that you don't get switches too often. Getting a switch every few minutes on a busy production system is acceptable. How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Oracle 11g Redo Log size Ask Question.

Asked 4 years, 8 months ago. Active 3 years, 3 months ago. Viewed times. GROUP , a. Redo Log File. Resize Redo Logs The default size of redo logs during installation is 50MB which is too small for production databases. Remove Redo Log Files Now, you have to remove these physical log files by yourself, otherwise you will receive ORA created file already exists.

As you can see, "resize" is actually repeated dropping and adding process, no magic inside. Further reading: How to Determine Archived Log Size Besides to resize redo log files to improve performance, you may also consider to move redo logs to faster disks.