1 2 Previous Next 20 Replies Latest reply: Sep 25, 2013 2:28 AM by yxes2013 Go to original post RSS
      • 15. Re: Monitoring DG Physical standby
        yxes2013

        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

          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....

            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

              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

                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

                  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