Re: Resize redo logs
From: Tom76 <brk15_at_hotmail.com>
Date: Mon, 21 Sep 2009 12:50:34 -0700 (PDT)
Message-ID: <6ce8304a-b26d-4688-8612-66658f7aaf09_at_j19g2000vbp.googlegroups.com>
On Sep 21, 2:52 pm, ddf <orat..._at_msn.com> wrote:
> On Sep 21, 12:53 pm, Tom76 <br..._at_hotmail.com> wrote:
>
> > On Sep 21, 1:50 pm, Tom76 <br..._at_hotmail.com> 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
Date: Mon, 21 Sep 2009 12:50:34 -0700 (PDT)
Message-ID: <6ce8304a-b26d-4688-8612-66658f7aaf09_at_j19g2000vbp.googlegroups.com>
On Sep 21, 2:52 pm, ddf <orat..._at_msn.com> wrote:
> On Sep 21, 12:53 pm, Tom76 <br..._at_hotmail.com> wrote:
>
> > On Sep 21, 1:50 pm, Tom76 <br..._at_hotmail.com> 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