This discussion is archived
13 Replies Latest reply: Jul 2, 2012 11:06 PM by MahirM.Quluzade RSS

Standby Log corruption -- in Recover phase

user10697869 Newbie
Currently Being Moderated
Hi All,
I am trying to set up RAC to RAC dataguard between 2 databases in different data centers.
I am able to ship archivelogs from primary to DR. The logs are not getting applied.


In the standby alert log -- I see the following errors (several of these CORRUPTION DETECTED Errors)

CORRUPTION DETECTED: In redo blocks starting at block 4097count 2048 for thread 4 sequence 15019
RFS[1185]: Possible network disconnect with primary database *Deleted Oracle managed file
+FR1/drdb/archivelog/2012_07_02/thread_4_seq_15019.578.787560321*
RFS[1186]: Possible network disconnect with primary database Mon Jul 02 06:45:36 2012
RFS[1189]: Assigned to RFS process 5016
RFS[1189]: Opened log for thread 2 sequence 12872 dbid 832151255 branch
782279895
*CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 2 sequence 12872 Deleted Oracle managed file
+FR1/drdb/archivelog/2012_07_02/thread_2_seq_12872.578.787560337*
Mon Jul 02 06:45:38 2012


another thing is -- I have another application, where there is dataguard from RAC to single instance. For this I dont see any problem..

can anybody throw some light on this problem?

Thanks in advance..

Krishna

Edited by: user10697869 on Jul 2, 2012 4:02 AM
  • 1. Re: Standby Log corruption -- in Recover phase
    KuljeetPalSingh Guru
    Currently Being Moderated
    Oracle Database uses the checksum to detect corruption in a redo log block. The database verifies the redo log block when the block is read from an archived log during recovery and when it writes the block to an archive log file. An error is raised and written to the alert log if corruption is detected.

    in your case, it appear archivelog got corrupted,try to transfer the archivelog again from primary to standby.
  • 2. Re: Standby Log corruption -- in Recover phase
    CKPT Guru
    Currently Being Moderated
    >
    CORRUPTION DETECTED: In redo blocks starting at block 4097count 2048 for thread 4 sequence 15019
    RFS[1185]: Possible network disconnect with primary database *Deleted Oracle managed file
    +FR1/drdb/archivelog/2012_07_02/thread_4_seq_15019.578.787560321*
    RFS[1186]: Possible network disconnect with primary database Mon Jul 02 06:45:36 2012
    RFS[1189]: Assigned to RFS process 5016
    RFS[1189]: Opened log for thread 2 sequence 12872 dbid 832151255 branch
    782279895
    *CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 2 sequence 12872 Deleted Oracle managed file
    +FR1/drdb/archivelog/2012_07_02/thread_2_seq_12872.578.787560337*
    Mon Jul 02 06:45:38 2012
    >

    Is it problem only with one/two archives? or happening with all of the archives?
    Can you do copy manually, register and apply only archives( Thread#4, Sequence# 15019, Thread#2, Sequence# 12972) ?

    and also after shipping what is the size please check as suggested by Kuljeet.

    >
    user10697869      
         Newbie
         
    Handle:      user10697869
    Status Level:      Newbie
    Registered:      Nov 2, 2011
    Total Posts:      9
    Total Questions:      5 (5 unresolved)
    >

    Why all of the questions are unanswered? mark the threads if answered and keep the forum clean

    Edited by: CKPT on Jul 2, 2012 5:22 PM
  • 3. Re: Standby Log corruption -- in Recover phase
    user10697869 Newbie
    Currently Being Moderated
    I dont see any corruption issues in Primary database. (on any node).
    I see corruption issue only on standby..

    there are several logs -- which has these issues.

    I tried applying manually.. it went through fine. -- ( i mean transfer archivelog on primary ASM to local disk on primary ---> ftp to DR --> apply archivelog --> recover manually ..
  • 4. Re: Standby Log corruption -- in Recover phase
    user10697869 Newbie
    Currently Being Moderated
    I saw..some logs size..I compared the sizes using
    ls -s < asm file name> --
    the size is same on both sides...
  • 5. Re: Standby Log corruption -- in Recover phase
    CKPT Guru
    Currently Being Moderated
    user10697869 wrote:
    I dont see any corruption issues in Primary database. (on any node).
    I see corruption issue only on standby..

    there are several logs -- which has these issues.

    I tried applying manually.. it went through fine. -- ( i mean transfer archivelog on primary ASM to local disk on primary ---> ftp to DR --> apply archivelog --> recover manually ..
    What is the format in both primary & standby?
    In standby where you have archive logs, any issues with Mount points/diskgroups?

    How To Check For Corrupt Or Invalid Archived Log Files [ID 177559.1]
  • 6. Re: Standby Log corruption -- in Recover phase
    user10697869 Newbie
    Currently Being Moderated
    DR: log_archive_format string %t_%s_%r.dbf
    Primary: log_archive_format string %t_%s_%r.dbf


    Now, I am having this error.

    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log
    07/02/2012 23:41:26
    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log
    07/02/2012 23:42:26
    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log

    FRA sizes on both DR & Primary are less than 50%.(i am checking V$FLASH_RECOVERY_AREA_USAGE)

    i have the following parameter:
    log_archive_dest_2='SERVICE=drdb LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=drdb' scope=both sid='*' ;
  • 7. Re: Standby Log corruption -- in Recover phase
    CKPT Guru
    Currently Being Moderated
    Hi,

    Error creating archivelog can be many reasons, it can be with FRA/log destination full also
    1) any clues from standby alert log file?
    2) FRA size on standby?
    >

    set lines 100
    col name format a60
    select     name
    ,     floor(space_limit / 1024 / 1024) "Size MB"
    ,     ceil(space_used / 1024 / 1024) "Used MB"
    from     v$recovery_file_dest
    order by name
    /
    >


    3) post below output from primary after couple of log switches

    SQL> select severity,errror_code,message,to_char(timestamp,'DD-MON-YYYY HH24:MI:SS') from v$dataguard_status where dest_id=2;
  • 8. Re: Standby Log corruption -- in Recover phase
    MahirM.Quluzade Guru
    Currently Being Moderated
    user10697869 wrote:
    Hi All,
    I am trying to set up RAC to RAC dataguard between 2 databases in different data centers.
    I am able to ship archivelogs from primary to DR. The logs are not getting applied.


    In the standby alert log -- I see the following errors (several of these CORRUPTION DETECTED Errors)

    CORRUPTION DETECTED: In redo blocks starting at block 4097count 2048 for thread 4 sequence 15019
    RFS[1185]: Possible network disconnect with primary database *Deleted Oracle managed file
    +FR1/drdb/archivelog/2012_07_02/thread_4_seq_15019.578.787560321*
    RFS[1186]: Possible network disconnect with primary database Mon Jul 02 06:45:36 2012
    RFS[1189]: Assigned to RFS process 5016
    RFS[1189]: Opened log for thread 2 sequence 12872 dbid 832151255 branch
    782279895
    *CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 2 sequence 12872 Deleted Oracle managed file
    +FR1/drdb/archivelog/2012_07_02/thread_2_seq_12872.578.787560337*
    Mon Jul 02 06:45:38 2012


    another thing is -- I have another application, where there is dataguard from RAC to single instance. For this I dont see any problem..

    can anybody throw some light on this problem?

    Thanks in advance..

    Krishna

    Edited by: user10697869 on Jul 2, 2012 4:02 AM
    Did you sure Transport service is running, becouse transport service automatically detect missing or corrupted archived redo log files on a standby system
    and automatically retrieve replacement archived redo log files from the primary database or another standby database.


    Regards
    Mahir M. Quluzade
    www.mahir-quluzade.com
  • 9. Re: Standby Log corruption -- in Recover phase
    user10697869 Newbie
    Currently Being Moderated
    standby alert log


    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Tue Jul 03 01:40:23 2012
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Tue Jul 03 01:41:40 2012
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:



    +FR1     1524000     31903


    Error 270 FAL[server, ARC2]: Error 270 creating remote archivelog file 'drdb' 03-JUL-2012 01:40:37
    Warning 270 ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270) 03-JUL-2012 01:40:37
    Warning 270 ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned 03-JUL-2012 01:40:37
    Error 270 FAL[server, ARC0]: Error 270 creating remote archivelog file 'drdb' 03-JUL-2012 01:40:37
    Warning 270 ARC3: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270) 03-JUL-2012 01:40:37
    Warning 270 ARC3: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned 03-JUL-2012 01:40:37
    Error 270 FAL[server, ARC3]: Error 270 creating remote archivelog file 'drdb' 03-JUL-2012 01:40:37
  • 10. Re: Standby Log corruption -- in Recover phase
    user10697869 Newbie
    Currently Being Moderated
    Right now, I dont have any corruption.

    INST_ID PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
    ---------- --------- ------------ ---------- ---------- ---------- ----------
    1 ARCH CLOSING 1 31 10240 1775
    1 ARCH CLOSING 3 32 8192 1243
    1 ARCH CONNECTED 0 0 0 0
    1 ARCH CLOSING 2 29 4096 1063
    1 ARCH CLOSING 4 31 4096 719
    1 RFS IDLE 0 0 0 0
    2 ARCH CLOSING 3 34 6144 1046
    2 ARCH CONNECTED 0 0 0 0
    2 ARCH CLOSING 1 22 6144 911
    2 ARCH CLOSING 3 35 10240 1556
    2 ARCH CLOSING 4 23 1 1946

    INST_ID PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
    ---------- --------- ------------ ---------- ---------- ---------- ----------
    2 RFS IDLE 0 0 0 0
    2 RFS IDLE 0 0 0 0
    2 RFS IDLE 0 0 0 0
    2 RFS IDLE 0 0 0 0
    2 RFS IDLE 0 0 0 0
    2 MRP0 WAIT_FOR_LOG 3 11753 0 0

    MRP0 is running -- but primary node say.. it cannot create archivelog..


    this is from broker log.

    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log
    07/03/2012 01:45:28
    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log
    07/03/2012 01:46:28
    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log

    i dont understand why there is an error in creating archivelog..

    I am printing my output of gv$logfile for both primary and standby..
    Is there any thing wrong in this config??


    "INST_ID"     "GROUP#"     "STATUS"     "TYPE"     "MEMBER"     "IS_RECOVERY_DEST_FILE"
    1     12     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_12.257.783544139"     "NO"
    1     10     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_10.257.784552287"     "NO"
    1     29     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_29.264.787264987"     "NO"
    1     11     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_11.258.784552299"     "NO"
    1     12     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_12.259.784552311"     "NO"
    1     13     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_13.260.784552323"     "NO"
    1     14     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_14.261.784552335"     "NO"
    1     15     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_15.262.784552347"     "NO"
    1     16     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_16.263.784552363"     "NO"
    1     17     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_17.264.784552377"     "NO"
    1     18     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_18.265.784552391"     "NO"
    1     19     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_19.266.784552403"     "NO"
    1     20     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_20.267.784552413"     "NO"
    1     21     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_21.268.784552423"     "NO"
    1     22     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_22.269.784552433"     "NO"
    1     23     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_23.270.784552445"     "NO"
    1     10     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_10.284.783543933"     "NO"
    1     24     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_24.271.784552453"     "NO"
    1     11     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_11.285.783543979"     "NO"
    1     13     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_13.286.783544253"     "NO"
    1     14     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_14.287.783544347"     "NO"
    1     15     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_15.288.783544531"     "NO"
    1     16     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_16.289.783544655"     "NO"
    1     17     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_17.290.783544659"     "NO"
    1     18     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_18.291.783544685"     "NO"
    1     19     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_19.292.783544691"     "NO"
    1     20     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_20.293.783544697"     "NO"
    1     21     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_21.294.783544701"     "NO"
    1     22     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_22.295.783544717"     "NO"
    1     23     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_23.296.783544721"     "NO"
    1     24     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_24.297.783544727"     "NO"
    1     25     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_25.298.783544731"     "NO"
    1     25     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_25.272.784552459"     "NO"
    1     29     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_29.4913.787264989"     "NO"
    1     30     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_30.320.787264993"     "NO"
    1     30     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_30.4912.787264995"     "NO"
    1     31     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_31.319.787264997"     "NO"
    1     31     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_31.4911.787264999"     "NO"
    1     32     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_32.318.787265001"     "NO"
    1     32     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_32.4910.787265003"     "NO"
    1     33     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_33.317.787265005"     "NO"
    1     33     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_33.4909.787265007"     "NO"
    1     34     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_34.316.787265009"     "NO"
    1     34     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_34.4908.787265011"     "NO"
    1     35     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_35.315.787265013"     "NO"
    1     35     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_35.4905.787265015"     "NO"
    1     36     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_36.314.787265019"     "NO"
    1     36     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_36.4904.787265021"     "NO"
    1     37     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_37.313.787265023"     "NO"
    1     37     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_37.4903.787265027"     "NO"
    1     38     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_38.312.787265029"     "NO"
    1     38     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_38.4902.787265031"     "NO"
    1     39     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_39.263.787265033"     "NO"
    1     39     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_39.4901.787265035"     "NO"
    1     40     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_40.278.787265037"     "NO"
    1     40     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_40.4899.787265039"     "NO"
    1     41     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_41.279.787265041"     "NO"
    1     41     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_41.4898.787265043"     "NO"
    1     42     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_42.277.787265047"     "NO"
    1     42     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_42.4897.787265049"     "NO"
    1     43     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_43.276.787265051"     "NO"
    1     43     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_43.4896.787265053"     "NO"
    1     44     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_44.275.787265055"     "NO"
    1     44     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_44.4894.787265057"     "NO"
    1     45     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_45.282.787265259"     "NO"
    1     45     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_45.4893.787265261"     "NO"
    1     47     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_47.324.787265263"     "NO"
    1     47     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_47.4892.787265265"     "NO"
    1     48     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_48.325.787265267"     "NO"
    1     48     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_48.4891.787265269"     "NO"
    1     46     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_46.326.787265279"     "NO"
    1     46     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_46.4890.787265281"     "NO"
    3     12     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_12.257.783544139"     "NO"
    3     10     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_10.257.784552287"     "NO"
    3     29     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_29.264.787264987"     "NO"
    3     11     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_11.258.784552299"     "NO"
    3     12     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_12.259.784552311"     "NO"
    3     13     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_13.260.784552323"     "NO"
    3     14     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_14.261.784552335"     "NO"
    3     15     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_15.262.784552347"     "NO"
    3     16     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_16.263.784552363"     "NO"
    3     17     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_17.264.784552377"     "NO"
    3     18     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_18.265.784552391"     "NO"
    3     19     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_19.266.784552403"     "NO"
    3     20     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_20.267.784552413"     "NO"
    3     21     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_21.268.784552423"     "NO"
    3     22     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_22.269.784552433"     "NO"
    3     23     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_23.270.784552445"     "NO"
    3     10     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_10.284.783543933"     "NO"
    3     24     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_24.271.784552453"     "NO"
    3     11     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_11.285.783543979"     "NO"
    3     13     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_13.286.783544253"     "NO"
    3     14     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_14.287.783544347"     "NO"
    3     15     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_15.288.783544531"     "NO"
    3     16     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_16.289.783544655"     "NO"
    3     17     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_17.290.783544659"     "NO"
    3     18     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_18.291.783544685"     "NO"
    3     19     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_19.292.783544691"     "NO"
    3     20     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_20.293.783544697"     "NO"
    3     21     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_21.294.783544701"     "NO"
    3     22     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_22.295.783544717"     "NO"
    3     23     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_23.296.783544721"     "NO"
    3     24     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_24.297.783544727"     "NO"
    3     25     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_25.298.783544731"     "NO"
    3     25     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_25.272.784552459"     "NO"
    3     29     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_29.4913.787264989"     "NO"
    3     30     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_30.320.787264993"     "NO"
    3     30     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_30.4912.787264995"     "NO"
    3     31     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_31.319.787264997"     "NO"
    3     31     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_31.4911.787264999"     "NO"
    3     32     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_32.318.787265001"     "NO"
    3     32     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_32.4910.787265003"     "NO"
    3     33     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_33.317.787265005"     "NO"
    3     33     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_33.4909.787265007"     "NO"
    3     34     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_34.316.787265009"     "NO"
    3     34     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_34.4908.787265011"     "NO"
    3     35     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_35.315.787265013"     "NO"
    3     35     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_35.4905.787265015"     "NO"
    3     36     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_36.314.787265019"     "NO"
    3     36     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_36.4904.787265021"     "NO"
    3     37     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_37.313.787265023"     "NO"
    3     37     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_37.4903.787265027"     "NO"
    3     38     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_38.312.787265029"     "NO"
    3     38     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_38.4902.787265031"     "NO"
    3     39     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_39.263.787265033"     "NO"
    3     39     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_39.4901.787265035"     "NO"
    3     40     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_40.278.787265037"     "NO"
    3     40     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_40.4899.787265039"     "NO"
    3     41     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_41.279.787265041"     "NO"
    3     41     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_41.4898.787265043"     "NO"
    3     42     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_42.277.787265047"     "NO"
    3     42     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_42.4897.787265049"     "NO"
    3     43     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_43.276.787265051"     "NO"
    3     43     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_43.4896.787265053"     "NO"
    3     44     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_44.275.787265055"     "NO"
    3     44     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_44.4894.787265057"     "NO"
    3     45     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_45.282.787265259"     "NO"
    3     45     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_45.4893.787265261"     "NO"
    3     47     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_47.324.787265263"     "NO"
    3     47     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_47.4892.787265265"     "NO"
    3     48     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_48.325.787265267"     "NO"
    3     48     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_48.4891.787265269"     "NO"
    3     46     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_46.326.787265279"     "NO"
    3     46     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_46.4890.787265281"     "NO"
    2     12     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_12.257.783544139"     "NO"
    2     10     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_10.257.784552287"     "NO"
    2     29     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_29.264.787264987"     "NO"
    2     11     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_11.258.784552299"     "NO"
    2     12     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_12.259.784552311"     "NO"
    2     13     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_13.260.784552323"     "NO"
    2     14     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_14.261.784552335"     "NO"
    2     15     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_15.262.784552347"     "NO"
    2     16     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_16.263.784552363"     "NO"
    2     17     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_17.264.784552377"     "NO"
    2     18     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_18.265.784552391"     "NO"
    2     19     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_19.266.784552403"     "NO"
    2     20     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_20.267.784552413"     "NO"
    2     21     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_21.268.784552423"     "NO"
    2     22     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_22.269.784552433"     "NO"
    2     23     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_23.270.784552445"     "NO"
    2     10     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_10.284.783543933"     "NO"
    2     24     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_24.271.784552453"     "NO"
    2     11     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_11.285.783543979"     "NO"
    2     13     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_13.286.783544253"     "NO"
    2     14     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_14.287.783544347"     "NO"
    2     15     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_15.288.783544531"     "NO"
    2     16     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_16.289.783544655"     "NO"
    2     17     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_17.290.783544659"     "NO"
    2     18     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_18.291.783544685"     "NO"
    2     19     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_19.292.783544691"     "NO"
    2     20     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_20.293.783544697"     "NO"
    2     21     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_21.294.783544701"     "NO"
    2     22     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_22.295.783544717"     "NO"
    2     23     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_23.296.783544721"     "NO"
    2     24     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_24.297.783544727"     "NO"
    2     25     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_25.298.783544731"     "NO"
    2     25     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_25.272.784552459"     "NO"
    2     29     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_29.4913.787264989"     "NO"
    2     30     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_30.320.787264993"     "NO"
    2     30     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_30.4912.787264995"     "NO"
    2     31     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_31.319.787264997"     "NO"
    2     31     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_31.4911.787264999"     "NO"
    2     32     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_32.318.787265001"     "NO"
    2     32     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_32.4910.787265003"     "NO"
    2     33     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_33.317.787265005"     "NO"
    2     33     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_33.4909.787265007"     "NO"
    2     34     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_34.316.787265009"     "NO"
    2     34     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_34.4908.787265011"     "NO"
    2     35     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_35.315.787265013"     "NO"
    2     35     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_35.4905.787265015"     "NO"
    2     36     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_36.314.787265019"     "NO"
    2     36     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_36.4904.787265021"     "NO"
    2     37     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_37.313.787265023"     "NO"
    2     37     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_37.4903.787265027"     "NO"
    2     38     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_38.312.787265029"     "NO"
    2     38     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_38.4902.787265031"     "NO"
    2     39     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_39.263.787265033"     "NO"
    2     39     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_39.4901.787265035"     "NO"
    2     40     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_40.278.787265037"     "NO"
    2     40     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_40.4899.787265039"     "NO"
    2     41     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_41.279.787265041"     "NO"
    2     41     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_41.4898.787265043"     "NO"
    2     42     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_42.277.787265047"     "NO"
    2     42     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_42.4897.787265049"     "NO"
    2     43     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_43.276.787265051"     "NO"
    2     43     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_43.4896.787265053"     "NO"
    2     44     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_44.275.787265055"     "NO"
    2     44     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_44.4894.787265057"     "NO"
    2     45     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_45.282.787265259"     "NO"
    2     45     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_45.4893.787265261"     "NO"
    2     47     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_47.324.787265263"     "NO"
    2     47     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_47.4892.787265265"     "NO"
    2     48     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_48.325.787265267"     "NO"
    2     48     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_48.4891.787265269"     "NO"
    2     46     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_46.326.787265279"     "NO"
    2     46     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_46.4890.787265281"     "NO"
    4     12     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_12.257.783544139"     "NO"
    4     10     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_10.257.784552287"     "NO"
    4     29     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_29.264.787264987"     "NO"
    4     11     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_11.258.784552299"     "NO"
    4     12     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_12.259.784552311"     "NO"
    4     13     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_13.260.784552323"     "NO"
    4     14     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_14.261.784552335"     "NO"
    4     15     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_15.262.784552347"     "NO"
    4     16     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_16.263.784552363"     "NO"
    4     17     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_17.264.784552377"     "NO"
    4     18     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_18.265.784552391"     "NO"
    4     19     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_19.266.784552403"     "NO"
    4     20     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_20.267.784552413"     "NO"
    4     21     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_21.268.784552423"     "NO"
    4     22     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_22.269.784552433"     "NO"
    4     23     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_23.270.784552445"     "NO"
    4     10     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_10.284.783543933"     "NO"
    4     24     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_24.271.784552453"     "NO"
    4     11     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_11.285.783543979"     "NO"
    4     13     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_13.286.783544253"     "NO"
    4     14     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_14.287.783544347"     "NO"
    4     15     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_15.288.783544531"     "NO"
    4     16     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_16.289.783544655"     "NO"
    4     17     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_17.290.783544659"     "NO"
    4     18     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_18.291.783544685"     "NO"
    4     19     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_19.292.783544691"     "NO"
    4     20     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_20.293.783544697"     "NO"
    4     21     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_21.294.783544701"     "NO"
    4     22     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_22.295.783544717"     "NO"
    4     23     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_23.296.783544721"     "NO"
    4     24     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_24.297.783544727"     "NO"
    4     25     ""     "ONLINE"     "+DG1/primdb/onlinelog/group_25.298.783544731"     "NO"
    4     25     ""     "ONLINE"     "+REDO/primdb/onlinelog/group_25.272.784552459"     "NO"
    4     29     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_29.4913.787264989"     "NO"
    4     30     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_30.320.787264993"     "NO"
    4     30     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_30.4912.787264995"     "NO"
    4     31     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_31.319.787264997"     "NO"
    4     31     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_31.4911.787264999"     "NO"
    4     32     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_32.318.787265001"     "NO"
    4     32     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_32.4910.787265003"     "NO"
    4     33     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_33.317.787265005"     "NO"
    4     33     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_33.4909.787265007"     "NO"
    4     34     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_34.316.787265009"     "NO"
    4     34     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_34.4908.787265011"     "NO"
    4     35     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_35.315.787265013"     "NO"
    4     35     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_35.4905.787265015"     "NO"
    4     36     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_36.314.787265019"     "NO"
    4     36     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_36.4904.787265021"     "NO"
    4     37     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_37.313.787265023"     "NO"
    4     37     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_37.4903.787265027"     "NO"
    4     38     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_38.312.787265029"     "NO"
    4     38     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_38.4902.787265031"     "NO"
    4     39     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_39.263.787265033"     "NO"
    4     39     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_39.4901.787265035"     "NO"
    4     40     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_40.278.787265037"     "NO"
    4     40     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_40.4899.787265039"     "NO"
    4     41     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_41.279.787265041"     "NO"
    4     41     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_41.4898.787265043"     "NO"
    4     42     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_42.277.787265047"     "NO"
    4     42     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_42.4897.787265049"     "NO"
    4     43     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_43.276.787265051"     "NO"
    4     43     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_43.4896.787265053"     "NO"
    4     44     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_44.275.787265055"     "NO"
    4     44     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_44.4894.787265057"     "NO"
    4     45     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_45.282.787265259"     "NO"
    4     45     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_45.4893.787265261"     "NO"
    4     47     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_47.324.787265263"     "NO"
    4     47     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_47.4892.787265265"     "NO"
    4     48     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_48.325.787265267"     "NO"
    4     48     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_48.4891.787265269"     "NO"
    4     46     ""     "STANDBY"     "+DG1/primdb/onlinelog/group_46.326.787265279"     "NO"
    4     46     ""     "STANDBY"     "+FR1/primdb/onlinelog/group_46.4890.787265281"     "NO"
  • 11. Re: Standby Log corruption -- in Recover phase
    user10697869 Newbie
    Currently Being Moderated
    "INST_ID"     "GROUP#"     "STATUS"     "TYPE"     "MEMBER"     "IS_RECOVERY_DEST_FILE"
    1     12     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_12.371.787521703"     "NO"
    1     45     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_45.359.787521463"     "NO"
    1     45     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_45.301.787521473"     "NO"
    1     10     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_10.369.787521693"     "NO"
    1     29     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_29.360.787521463"     "NO"
    1     11     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_11.370.787521699"     "NO"
    1     12     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_12.313.787521707"     "NO"
    1     13     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_13.372.787521709"     "NO"
    1     14     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_14.373.787521715"     "NO"
    1     15     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_15.374.787521719"     "NO"
    1     16     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_16.375.787521725"     "NO"
    1     17     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_17.376.787521731"     "NO"
    1     18     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_18.377.787521735"     "NO"
    1     19     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_19.378.787521741"     "NO"
    1     20     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_20.379.787521745"     "NO"
    1     21     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_21.380.787521751"     "NO"
    1     22     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_22.381.787521757"     "NO"
    1     29     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_29.302.787521473"     "NO"
    1     47     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_47.361.787521463"     "NO"
    1     47     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_47.303.787521473"     "NO"
    1     30     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_30.362.787521463"     "NO"
    1     30     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_30.304.787521473"     "NO"
    1     31     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_31.363.787521465"     "NO"
    1     31     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_31.305.787521473"     "NO"
    1     23     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_23.382.787521761"     "NO"
    1     10     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_10.311.787521697"     "NO"
    1     24     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_24.383.787521767"     "NO"
    1     11     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_11.312.787521701"     "NO"
    1     32     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_32.364.787521483"     "NO"
    1     13     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_13.314.787521711"     "NO"
    1     32     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_32.306.787521489"     "NO"
    1     14     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_14.315.787521717"     "NO"
    1     37     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_37.365.787521483"     "NO"
    1     15     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_15.316.787521721"     "NO"
    1     37     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_37.307.787521489"     "NO"
    1     16     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_16.317.787521727"     "NO"
    1     38     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_38.366.787521483"     "NO"
    1     17     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_17.318.787521733"     "NO"
    1     18     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_18.319.787521737"     "NO"
    1     19     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_19.320.787521743"     "NO"
    1     20     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_20.321.787521749"     "NO"
    1     21     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_21.322.787521753"     "NO"
    1     22     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_22.323.787521759"     "NO"
    1     23     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_23.324.787521765"     "NO"
    1     24     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_24.325.787521769"     "NO"
    1     25     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_25.384.787521771"     "NO"
    1     25     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_25.326.787521775"     "NO"
    1     38     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_38.308.787521489"     "NO"
    1     39     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_39.367.787521495"     "NO"
    1     39     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_39.309.787521499"     "NO"
    1     40     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_40.368.787521495"     "NO"
    1     40     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_40.310.787521499"     "NO"
    1     48     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_48.385.787525773"     "NO"
    1     48     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_48.338.787525779"     "NO"
    1     41     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_41.386.787525773"     "NO"
    1     41     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_41.337.787525779"     "NO"
    1     33     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_33.387.787525775"     "NO"
    1     33     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_33.332.787525781"     "NO"
    1     42     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_42.388.787525785"     "NO"
    1     42     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_42.334.787525791"     "NO"
    1     34     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_34.389.787525785"     "NO"
    1     34     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_34.331.787525793"     "NO"
    1     35     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_35.390.787525785"     "NO"
    1     35     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_35.330.787525793"     "NO"
    1     43     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_43.391.787525797"     "NO"
    1     43     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_43.339.787525803"     "NO"
    1     36     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_36.392.787525797"     "NO"
    1     36     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_36.340.787525805"     "NO"
    1     44     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_44.393.787525799"     "NO"
    1     44     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_44.341.787525805"     "NO"
    1     46     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_46.394.787525809"     "NO"
    1     46     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_46.342.787525811"     "NO"
    2     12     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_12.371.787521703"     "NO"
    2     45     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_45.359.787521463"     "NO"
    2     45     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_45.301.787521473"     "NO"
    2     10     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_10.369.787521693"     "NO"
    2     29     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_29.360.787521463"     "NO"
    2     11     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_11.370.787521699"     "NO"
    2     12     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_12.313.787521707"     "NO"
    2     13     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_13.372.787521709"     "NO"
    2     14     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_14.373.787521715"     "NO"
    2     15     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_15.374.787521719"     "NO"
    2     16     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_16.375.787521725"     "NO"
    2     17     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_17.376.787521731"     "NO"
    2     18     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_18.377.787521735"     "NO"
    2     19     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_19.378.787521741"     "NO"
    2     20     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_20.379.787521745"     "NO"
    2     21     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_21.380.787521751"     "NO"
    2     22     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_22.381.787521757"     "NO"
    2     29     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_29.302.787521473"     "NO"
    2     47     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_47.361.787521463"     "NO"
    2     47     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_47.303.787521473"     "NO"
    2     30     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_30.362.787521463"     "NO"
    2     30     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_30.304.787521473"     "NO"
    2     31     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_31.363.787521465"     "NO"
    2     31     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_31.305.787521473"     "NO"
    2     23     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_23.382.787521761"     "NO"
    2     10     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_10.311.787521697"     "NO"
    2     24     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_24.383.787521767"     "NO"
    2     11     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_11.312.787521701"     "NO"
    2     32     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_32.364.787521483"     "NO"
    2     13     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_13.314.787521711"     "NO"
    2     32     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_32.306.787521489"     "NO"
    2     14     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_14.315.787521717"     "NO"
    2     37     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_37.365.787521483"     "NO"
    2     15     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_15.316.787521721"     "NO"
    2     37     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_37.307.787521489"     "NO"
    2     16     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_16.317.787521727"     "NO"
    2     38     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_38.366.787521483"     "NO"
    2     17     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_17.318.787521733"     "NO"
    2     18     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_18.319.787521737"     "NO"
    2     19     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_19.320.787521743"     "NO"
    2     20     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_20.321.787521749"     "NO"
    2     21     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_21.322.787521753"     "NO"
    2     22     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_22.323.787521759"     "NO"
    2     23     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_23.324.787521765"     "NO"
    2     24     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_24.325.787521769"     "NO"
    2     25     ""     "ONLINE"     "+DG1/drdb/onlinelog/group_25.384.787521771"     "NO"
    2     25     ""     "ONLINE"     "+FR1/drdb/onlinelog/group_25.326.787521775"     "NO"
    2     38     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_38.308.787521489"     "NO"
    2     39     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_39.367.787521495"     "NO"
    2     39     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_39.309.787521499"     "NO"
    2     40     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_40.368.787521495"     "NO"
    2     40     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_40.310.787521499"     "NO"
    2     48     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_48.385.787525773"     "NO"
    2     48     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_48.338.787525779"     "NO"
    2     41     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_41.386.787525773"     "NO"
    2     41     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_41.337.787525779"     "NO"
    2     33     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_33.387.787525775"     "NO"
    2     33     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_33.332.787525781"     "NO"
    2     42     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_42.388.787525785"     "NO"
    2     42     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_42.334.787525791"     "NO"
    2     34     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_34.389.787525785"     "NO"
    2     34     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_34.331.787525793"     "NO"
    2     35     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_35.390.787525785"     "NO"
    2     35     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_35.330.787525793"     "NO"
    2     43     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_43.391.787525797"     "NO"
    2     43     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_43.339.787525803"     "NO"
    2     36     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_36.392.787525797"     "NO"
    2     36     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_36.340.787525805"     "NO"
    2     44     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_44.393.787525799"     "NO"
    2     44     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_44.341.787525805"     "NO"
    2     46     ""     "STANDBY"     "+DG1/drdb/onlinelog/group_46.394.787525809"     "NO"
    2     46     ""     "STANDBY"     "+FR1/drdb/onlinelog/group_46.342.787525811"     "NO"
  • 12. Re: Standby Log corruption -- in Recover phase
    CKPT Guru
    Currently Being Moderated
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Tue Jul 03 01:40:23 2012
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Tue Jul 03 01:41:40 2012
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Errors in file /u01/app/oracle/diag/rdbms/drdb/drdb1/trace/drdb1_ora_11266.trc:
    Can you post what exist in trace files?
    Also what is your database version?
    +FR1     1524000     31903
    It has enough space, So only 31 gb used out of 1500gb.
    Error 270 FAL[server, ARC2]: Error 270 creating remote archivelog file 'drdb' 03-JUL-2012 01:40:37
    Warning 270 ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270) 03-JUL-2012 01:40:37
    Warning 270 ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned 03-JUL-2012 01:40:37
    Error 270 FAL[server, ARC0]: Error 270 creating remote archivelog file 'drdb' 03-JUL-2012 01:40:37
    Warning 270 ARC3: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270) 03-JUL-2012 01:40:37
    Warning 270 ARC3: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned 03-JUL-2012 01:40:37
    Error 270 FAL[server, ARC3]: Error 270 creating remote archivelog file 'drdb' 03-JUL-2012 01:40:37
    Looks like there in network connection and causing to failure creating remote archivelog. Can you please concentrate on bandwidth speed?
  • 13. Re: Standby Log corruption -- in Recover phase
    MahirM.Quluzade Guru
    Currently Being Moderated
    Please , check you recovery area destination size on standby and primary, if you have space increase both.
    becouse you are get error
    Redo transport problem detected: redo transport for database drdb has the following error:
    ORA-00270: error creating archive log

Legend

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