Re: Redolog movement
Date: Wed, 26 Jun 2013 11:47:34 -0300
Message-ID: <CAJ2dSGRc_5-m1CUd1VpONbsuyr8dB4B=7WTpsCatY2m7XcovpA_at_mail.gmail.com>
It really depends on your approach to moving the redo logs. If you choose to simply move them, then you need to stop the database and recreate the controlfile. A bit of an overkill.
If you want to keep the same size for the redo logs but simply move them to a new destination then you can simply add a member to the groups and then drop the old member, this is online, and does not require any application (golden gate included) to be stopped.
If you want to change the size in addition to chaning the location, then you need to create new groups for each thread and then drop theold groups. This is still an online operation, but you need to wait until the old groups are cleared (or force a checkpoint?) before you remove them. I don't know if dropping an INACTIVE group will have any impact on GG, but it should not, as GG can go to the archivelogs for older data.
Alan.-
On Wed, Jun 26, 2013 at 10:45 AM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
> thanks for your reply! I assume we need to stop the application that were
> intended to replicate
>
>
> On Wed, Jun 26, 2013 at 7:07 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com
> > wrote:
>
>> Short answer: it will have no significant impact.
>>
>> at worst it may cause an ABEND in the extract process and then you just
>> restart the process.
>>
>> I would suggest, however, testing this in development or QA environments
>> before performing it in production. Then again, I suggest that for just
>> about any change :P
>>
>> Cheers.-
>>
>> Alan.-
>>
>>
>> On Wed, Jun 26, 2013 at 4:48 AM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
>>
>>> Hello Gurus!
>>> We have 2 node RAC and redologs are configured in RAID 5 disk, Since we
>>> noticed the performance is slow we planned to move the redo logfiles to
>>> RAID 1 disk.
>>> We configured OGG from primary cluster to secondary cluster,in this
>>> situation will my OGG extract process will be affected due to redo log
>>> movement? Please advise
>>>
>>> -Nagaraj
>>>
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 26 2013 - 16:47:34 CEST