0 Replies Latest reply: Aug 17, 2013 9:42 PM by rontrinidadcabral RSS

    physical standby unused thread, ORL size etc

    rontrinidadcabral

      Hi,

       

      Anyone who had experience resizing ORL of unused thread in Physical standby in RAC? Can you share the steps? thanks.

       

      Environment:

      Oracle 11.2.0.2

       

      primary:
      SQL> select thread#,status,enabled,CHECKPOINT_TIME from v$thread;

         THREAD# STATUS ENABLED  CHECKPOIN
      ---------- ------ -------- ---------
               1 OPEN   PUBLIC   17-AUG-13
               2 OPEN   PUBLIC   15-AUG-13
               3 OPEN   PUBLIC   17-AUG-13
               4 OPEN   PUBLIC   17-AUG-13
               5 OPEN   PUBLIC   17-AUG-13

       

      standby:

      SQL>select thread#,status,enabled,CHECKPOINT_TIME from v$thread;

         THREAD# STATUS ENABLED  CHECKPOIN
      ---------- ------ -------- ---------
               1 OPEN   PUBLIC   21-OCT-12
               2 OPEN   PUBLIC   21-OCT-12
               3 OPEN   PUBLIC   21-OCT-12
               4 OPEN   PRIVATE
               5 OPEN   PRIVATE


      SQL>select group#,thread#,bytes,status from v$log;

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

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