This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Sep 25, 2013 12:28 AM by yxes2013 Go to original post RSS
  • 15. Re: Monitoring DG Physical standby
    yxes2013 Newbie
    Currently Being Moderated

    Thanks Saur,

     

    I checked the FRA archivelogs and I can see that the file was there but they are duplicates? What causes this duplicates? Can I just delete the dup or replace them entirely from

    primary.

     

    proddr:oracle[/backup/flash_recovery_area/PRODDR/archivelog/2013_09_25] ls -l

    total 4273224

    -rw-r-----    1 oracle   oinstall   86111744 Sep 25 11:35 o1_mf_1_2179_944nqv1j_.arc

    -rw-r-----    1 oracle   oinstall   86023168 Sep 25 11:52 o1_mf_1_2180_944nqv2b_.arc

    -rw-r-----    1 oracle   oinstall   85985792 Sep 25 11:34 o1_mf_1_2181_944nqv35_.arc

    -rw-r-----    1 oracle   oinstall   85931520 Sep 25 12:43 o1_mf_1_2182_944rdys2_.arc

    -rw-r-----    1 oracle   oinstall   96232448 Sep 25 12:16 o1_mf_1_2183_944phgbj_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 12:38 o1_mf_1_2184_944qj8rm_.arc

    -rw-r-----    1 oracle   oinstall   87421952 Sep 25 12:54 o1_mf_1_2185_944rwc8p_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 13:22 o1_mf_1_2186_944t72sc_.arc

    -rw-r-----    1 oracle   oinstall   87962112 Sep 25 13:22 o1_mf_1_2187_944thh9y_.arc

    -rw-r-----    1 oracle   oinstall   93844480 Sep 25 13:34 o1_mf_1_2188_944v3nsp_.arc

    -rw-r-----    1 oracle   oinstall   86327808 Sep 25 13:56 o1_mf_1_2189_944wqtto_.arc

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 02:06 o1_mf_1_2190_943hjqpp_.arc

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 13:56 o1_mf_1_2190_944wqwy1_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 04:19 o1_mf_1_2191_943o4r7d_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 14:14 o1_mf_1_2191_944xgm1q_.arc

    -rw-r-----    1 oracle   oinstall   85939200 Sep 25 06:55 o1_mf_1_2192_943wyn1x_.arc

    -rw-r-----    1 oracle   oinstall   85939200 Sep 25 14:33 o1_mf_1_2192_944yqrh3_.arc

    -rw-r-----    1 oracle   oinstall   86021120 Sep 25 08:55 o1_mf_1_2193_94462r8g_.arc

    -rw-r-----    1 oracle   oinstall   86021120 Sep 25 14:34 o1_mf_1_2193_944yqrwm_.arc

    -rw-r-----    1 oracle   oinstall   86032384 Sep 25 10:05 o1_mf_1_2194_944f3lp0_.arc

    -rw-r-----    1 oracle   oinstall   86032384 Sep 25 14:35 o1_mf_1_2194_944ztog7_.arc

    -rw-r-----    1 oracle   oinstall   85987328 Sep 25 11:56 o1_mf_1_2195_944qqs6n_.arc

    -rw-r-----    1 oracle   oinstall     302592 Sep 25 14:33 o1_mf_1_2196_9450xw7o_.arc

    -rw-r-----    1 oracle   oinstall   86038016 Sep 25 12:32 o1_mf_1_2197_944svghj_.arc

    -rw-r-----    1 oracle   oinstall   85983744 Sep 25 13:10 o1_mf_1_2198_944w2rnd_.arc

    -rw-r-----    1 oracle   oinstall   86058496 Sep 25 14:02 o1_mf_1_2199_944z4gd6_.arc

  • 16. Re: Monitoring DG Physical standby
    saurabh Pro
    Currently Being Moderated

    i don't think they are duplicate files.

     

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 02:06 o1_mf_1_2190_943hjqpp_.arc

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 13:56 o1_mf_1_2190_944wqwy1_.arc

  • 17. Re: Monitoring DG Physical standby
    Aman.... Oracle ACE
    Currently Being Moderated

    Follow the suggestion of Saurabh to recover the standby manually. And am not sure how did you think that a primary would generate duplicated archived logs?

     

    Aman....

  • 18. Re: Monitoring DG Physical standby
    yxes2013 Newbie
    Currently Being Moderated

    yeah but they are the sequece missing? 2190-2194, and all the archivelogs from PRIMARY and STANDBY sites have diffrent archivelog name?

     

    This is from PRIMARY:

    =================

    primary:oracle[/backup/flash_recovery_area/PROD/archivelog/2013_09_25] ls -lt

    total 1871904

    -rw-r-----    1 oracle   oinstall   86039552 Sep 25 14:46 o1_mf_1_2200_9451o7o1_.arc

    -rw-r-----    1 oracle   oinstall   86058496 Sep 25 14:00 o1_mf_1_2199_944z03fx_.arc

    -rw-r-----    1 oracle   oinstall   85983744 Sep 25 13:08 o1_mf_1_2198_944vyj6m_.arc

    -rw-r-----    1 oracle   oinstall   86038016 Sep 25 12:07 o1_mf_1_2197_944rdrvt_.arc

    -rw-r-----    1 oracle   oinstall     302592 Sep 25 11:10 o1_mf_1_2196_944o0tql_.arc

    -rw-r-----    1 oracle   oinstall   85987328 Sep 25 11:10 o1_mf_1_2195_944o0dnr_.arc

    -rw-r-----    1 oracle   oinstall   86032384 Sep 25 10:06 o1_mf_1_2194_944k8ldk_.arc

    -rw-r-----    1 oracle   oinstall   86021120 Sep 25 08:55 o1_mf_1_2193_944f4d5c_.arc

    -rw-r-----    1 oracle   oinstall   85939200 Sep 25 06:55 o1_mf_1_2192_94463ksf_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 04:00 o1_mf_1_2191_943vtqsh_.arc

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 02:06 o1_mf_1_2190_943o5kqz_.arc

    -rw-r-----    1 oracle   oinstall   86327808 Sep 25 00:24 o1_mf_1_2189_943h64y1_.arc


    And this is from STANDBY:

    =========================


    standby:oracle[/backup/flash_recovery_area/PRODDR/archivelog/2013_09_25] ls -l

    total 4502800

    -rw-r-----    1 oracle   oinstall   86111744 Sep 25 11:35 o1_mf_1_2179_944nqv1j_.arc

    -rw-r-----    1 oracle   oinstall   86023168 Sep 25 11:52 o1_mf_1_2180_944nqv2b_.arc

    -rw-r-----    1 oracle   oinstall   85985792 Sep 25 11:34 o1_mf_1_2181_944nqv35_.arc

    -rw-r-----    1 oracle   oinstall   85931520 Sep 25 12:43 o1_mf_1_2182_944rdys2_.arc

    -rw-r-----    1 oracle   oinstall   96232448 Sep 25 12:16 o1_mf_1_2183_944phgbj_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 12:38 o1_mf_1_2184_944qj8rm_.arc

    -rw-r-----    1 oracle   oinstall   87421952 Sep 25 12:54 o1_mf_1_2185_944rwc8p_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 13:22 o1_mf_1_2186_944t72sc_.arc

    -rw-r-----    1 oracle   oinstall   87962112 Sep 25 13:22 o1_mf_1_2187_944thh9y_.arc

    -rw-r-----    1 oracle   oinstall   93844480 Sep 25 13:34 o1_mf_1_2188_944v3nsp_.arc

    -rw-r-----    1 oracle   oinstall   86327808 Sep 25 13:56 o1_mf_1_2189_944wqtto_.arc

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 02:06 o1_mf_1_2190_943hjqpp_.arc

    -rw-r-----    1 oracle   oinstall   85938688 Sep 25 13:56 o1_mf_1_2190_944wqwy1_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 04:19 o1_mf_1_2191_943o4r7d_.arc

    -rw-r-----    1 oracle   oinstall   97719808 Sep 25 14:14 o1_mf_1_2191_944xgm1q_.arc

    -rw-r-----    1 oracle   oinstall   85939200 Sep 25 06:55 o1_mf_1_2192_943wyn1x_.arc

    -rw-r-----    1 oracle   oinstall   85939200 Sep 25 14:33 o1_mf_1_2192_944yqrh3_.arc

    -rw-r-----    1 oracle   oinstall   86021120 Sep 25 08:55 o1_mf_1_2193_94462r8g_.arc

    -rw-r-----    1 oracle   oinstall   86021120 Sep 25 14:34 o1_mf_1_2193_944yqrwm_.arc

    -rw-r-----    1 oracle   oinstall   86032384 Sep 25 10:05 o1_mf_1_2194_944f3lp0_.arc

    -rw-r-----    1 oracle   oinstall   86032384 Sep 25 14:40 o1_mf_1_2194_944ztog7_.arc

    -rw-r-----    1 oracle   oinstall   85987328 Sep 25 11:56 o1_mf_1_2195_944qqs6n_.arc

    -rw-r-----    1 oracle   oinstall     302592 Sep 25 14:33 o1_mf_1_2196_9450xw7o_.arc

    -rw-r-----    1 oracle   oinstall   86038016 Sep 25 12:32 o1_mf_1_2197_944svghj_.arc

    -rw-r-----    1 oracle   oinstall   85983744 Sep 25 13:10 o1_mf_1_2198_944w2rnd_.arc

    -rw-r-----    1 oracle   oinstall   86058496 Sep 25 14:02 o1_mf_1_2199_944z4gd6_.arc

    -rw-r-----    1 oracle   oinstall   86039552 Sep 25 14:45 o1_mf_1_2200_9451nfm2_.arc

     

    Note that the sequence number and file size are equal but the extension unique name is different? Maybe dataguard just check or lookup at the sequence number?

    And why is that they have different folder contents with respect to nos. of archivelogs?

     

    Thanks

     

    Message was edited by: yxes2013

  • 19. Re: Monitoring DG Physical standby
    yxes2013 Newbie
    Currently Being Moderated

    YESSSS!!!! I just deleted the duplicates and the gap was fixed and applied   I am a good dba now? Have you encountered this before?

     

    It is very hard to do trial and error test on PROD database especially when you do not have test server to replicate the issue?

    Good thing you are there always for me. I appreciate your help very much.

  • 20. Re: Monitoring DG Physical standby
    yxes2013 Newbie
    Currently Being Moderated

    Just remember this folks! The archivelogs are just checking the archive log sequence number, and they have different names comparing the PRIMARY and STANDBY archivelog.

1 2 Previous Next

Legend

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