Handling ORL and SRL (Resize) on Primary and Physical Standby in Data Guard Environment

(Doc ID 1532566.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Goal

It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is over frequently. So suggestion is to Increase the Size of the Online Redologs to reduce Redolog Switch Frequency. And this may also required to improve primary database performance.

So the purpose of this article is How to Increase size of Redo Logs in a Dataguard Environment when Physical Standby in place.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms