Re: Resize redo logs

From: ddf <>
Date: Mon, 21 Sep 2009 11:52:17 -0700 (PDT)
Message-ID: <>

On Sep 21, 12:53 pm, Tom76 <> wrote:
> On Sep 21, 1:50 pm, Tom76 <> wrote:
> > Need to resize online and standby redo logs for a DataGuard(primary
> > and physical dataguard). What is the procedure?
> primary and physical standby database.

To keep things working properly through Data Guard you'll need to create the new logs/groups of the proper size on the primary then create new logs/groups on the standby. Once you have all of your new, larger redo logs/groups in place on both servers you can switch logfiles until the the first of the newer, larger logs is in use. Usually you could simply switch logfiles until the first group is no longer active, drop it, and recreate it with a larger size, but the standby database relies upon the fact that the standby redo logs exactly mirror the primary redo logs. This is why you must create the larger logs first, on both systems, so that when the log switch on the primary gets to the larger log a matching log on the standby will be found. When the smaller redo logs are shown as INACTIVE you should be able to drop them from both the primary and the standby leaving only the 'resized' logs in place. Yes, this 'upsets' your log group numbering but that won't matter to Oracle as long as the logs/groups match on both primary and standby databases.

David Fitzjarrell Received on Mon Sep 21 2009 - 13:52:17 CDT

Original text of this message