Re: Resize redo logs

From: Tom76 <>
Date: Mon, 21 Sep 2009 12:50:34 -0700 (PDT)
Message-ID: <>

On Sep 21, 2:52 pm, ddf <> wrote:
> 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

Is it possible that I can drop the SRL on the standby(and primary) before I add and drop redo logs. The standby then starts using the RFS process to maitain the standby. Once the addition/deletion of redo logs is done, I can add SRLs on standby and primary. Is this possible. Received on Mon Sep 21 2009 - 14:50:34 CDT

Original text of this message