This discussion is archived
5 Replies Latest reply: Aug 14, 2013 2:15 AM by Abufazal RSS

Resizing Redo Logs in Data Guard Configuration

aDBA Newbie
Currently Being Moderated
I have a Data Guard configuration with one primary and one physical standby. The primary has online redo logs and standby redo logs. The standby has standby redo logs too. Now I need to enlarge the primary's online redo logs, what are the proper way to do this? I know the procedures in non-DataGuard situation: adding new redo groups with right size, doing log switches, and removing the old ones.

Thanks.
  • 1. Re: Resizing Redo Logs in Data Guard Configuration
    Shivananda Rao Guru
    Currently Being Moderated
    Hi,

    1. Cancel the MRP on standby database.

    2. Increase the size of the Online redo log file size in primary by adding new log files with the preferred size and perform log switches, drop the old inactive redo log files.

    3. Drop the Standby Redo log files on the Primary database and add new standby redo log files with the size that you created the new Online Redo Logs.

    4. On Standby, drop the existing Standby Redo Log Files and create new standby redo log files with the size that you created the new Online Redo logs on Primary.

    5. Start the MRP on standby database.

    You can take a look at http://emrebaransel.blogspot.in/2008/08/changing-log-file-size-on-dataguard.html
  • 2. Re: Resizing Redo Logs in Data Guard Configuration
    aDBA Newbie
    Currently Being Moderated
    Thank you. I will test it out.
  • 3. Re: Resizing Redo Logs in Data Guard Configuration
    10d67c14-3c0e-4858-b748-42ef159e461d Newbie
    Currently Being Moderated

    Hi ,

     

    Looks old post.

    But got perfect document in support.oracle.com for resizing online and standby redologs for dataguard configuration.

    1.Move standby database to manual management mode.

    2.drop and add orl and srl files.

    3.stop recovery on standby

    3.on standby clear,drop and add logfiles.

    4.start recovery and move database to auto management mode.

     

     

    Handling ORL and SRL (Resize) on Primary and Physical Standby in Dataguard Environment [ID 1532566.1]

  • 4. Re: Resizing Redo Logs in Data Guard Configuration
    rontrinidadcabral Newbie
    Currently Being Moderated

    I tried to resize ORL of physical standby DB; this is 2 node RAC but only thread 1,2,3 are active. primary is a 3 node RAC,

     

    but I cannot drop thread 5 ORL, these are UNUSED. ORA-1624 error.

     

    Any idea on how to fix this?

     

        GROUP#    THREAD# ARC STATUS                BYTES
    ---------- ---------- --- ---------------- ----------
             1          1 YES CLEARING         1073741824
             2          1 YES CLEARING         1073741824
             3          2 YES CURRENT          1073741824
             4          2 YES CLEARING         1073741824
             5          3 YES CLEARING         1073741824
             6          3 YES CLEARING         1073741824
             7          2 YES CLEARING         1073741824
             8          1 YES CURRENT          1073741824
             9          3 YES CURRENT          1073741824
            22          4 YES UNUSED            104857600
            23          4 YES UNUSED            104857600

        GROUP#    THREAD# ARC STATUS                BYTES
    ---------- ---------- --- ---------------- ----------
            24          5 YES UNUSED            104857600
            25          5 YES UNUSED            104857600

  • 5. Re: Resizing Redo Logs in Data Guard Configuration
    Abufazal Journeyer
    Currently Being Moderated

    Could you provide the commands that you are using and the errors that you are getting

     

    PS: Please submit your questions in a new thread instead of putting it into other's thread

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points