1 2 3 Previous Next 43 Replies Latest reply: Mar 11, 2014 8:07 PM by petra-K RSS

    Gaps exists again

      Hi all,

       

      11.2.0.1

      aix6

       

      We have experienced heavy network load lately such that our dataguard archivelog transfer is affected and there are lots of missing archivelogs

       

      For example:

      at PRIMARY : These are the existing files at FRA folder archivelog/2014_03_10

      -rw-------    1 oracle   oinstall   87638528 Mar 10 00:15 o1_mf_1_5192_9ks4x9vx_.arc

      -rw-------    1 oracle   oinstall   85970944 Mar 10 02:04 o1_mf_1_5193_9kscb3gq_.arc

      -rw-------    1 oracle   oinstall   97122304 Mar 10 04:00 o1_mf_1_5194_9ksl2rt6_.arc

      -rw-------    1 oracle   oinstall   85947904 Mar 10 08:24 o1_mf_1_5195_9kt1l651_.arc

      -rw-------    1 oracle   oinstall   86099968 Mar 10 09:58 o1_mf_1_5196_9kt71vx5_.arc

      -rw-------    1 oracle   oinstall   86146560 Mar 10 11:00 o1_mf_1_5197_9ktbp1f5_.arc

      -rw-------    1 oracle   oinstall   86166016 Mar 10 12:08 o1_mf_1_5198_9ktgphq1_.arc

      -rw-------    1 oracle   oinstall   85957632 Mar 10 13:16 o1_mf_1_5199_9ktlp5yr_.arc

      -rw-------    1 oracle   oinstall   86078464 Mar 10 14:07 o1_mf_1_5200_9ktonf6x_.arc

      -rw-------    1 oracle   oinstall   86052864 Mar 10 14:55 o1_mf_1_5201_9ktrhcgy_.arc

      -rw-------    1 oracle   oinstall   86071296 Mar 10 15:34 o1_mf_1_5202_9kttrz0s_.arc

      -rw-------    1 oracle   oinstall   86181888 Mar 10 16:11 o1_mf_1_5203_9ktwxz8m_.arc

      -rw-------    1 oracle   oinstall   86039040 Mar 10 16:55 o1_mf_1_5204_9ktzj6gp_.arc

      -rw-------    1 oracle   oinstall   86110208 Mar 10 17:33 o1_mf_1_5205_9kv1pjpx_.arc

      -rw-------    1 oracle   oinstall   86018560 Mar 10 18:22 o1_mf_1_5206_9kv4lhwo_.arc

      -rw-------    1 oracle   oinstall   92037632 Mar 10 18:43 o1_mf_1_5207_9kv5v91g_.arc

      -rw-------    1 oracle   oinstall   91225088 Mar 10 18:44 o1_mf_1_5208_9kv5w73r_.arc

      -rw-------    1 oracle   oinstall   85981184 Mar 10 18:53 o1_mf_1_5209_9kv6g16f_.arc

      -rw-------    1 oracle   oinstall   86034944 Mar 10 20:32 o1_mf_1_5210_9kvd70jz_.arc

       

      While

      At STANDBY :

       

      The existing files at FRA folder archivelog/2014_03_10

       

      -rw-------    1 oracle   oinstall   85960704 Mar 10 20:45 o1_mf_1_5162_9kv86hqf_.arc

      -rw-------    1 oracle   oinstall   94267904 Mar 10 20:44 o1_mf_1_5163_9kv7mnry_.arc

      -rw-------    1 oracle   oinstall   85949440 Mar 10 20:43 o1_mf_1_5164_9kv588fo_.arc

      -rw-------    1 oracle   oinstall   87638528 Mar 10 00:30 o1_mf_1_5192_9ks5sv9v_.arc

      -rw-------    1 oracle   oinstall   85970944 Mar 10 02:09 o1_mf_1_5193_9kscm4jg_.arc

      -rw-------    1 oracle   oinstall   97122304 Mar 10 06:28 o1_mf_1_5194_9kstrrmh_.arc

      -rw-------    1 oracle   oinstall   85947904 Mar 10 09:50 o1_mf_1_5195_9kt6l9d7_.arc

      -rw-------    1 oracle   oinstall   86166016 Mar 10 14:57 o1_mf_1_5198_9ktrl2bl_.arc

      -rw-------    1 oracle   oinstall   86071296 Mar 10 17:55 o1_mf_1_5202_9kv3198l_.arc

      -rw-------    1 oracle   oinstall   86018560 Mar 10 19:39 o1_mf_1_5206_9kv94dy8_.arc

       

       

      Note that lots have been missing

       

      My question is which folder should I copy the MISSING archive logs? Note that the lowest in PRIMARY is 5192  while at STANBY it is 5162?  If I copy all the primary to that same folder, this will make more file contents of the same folders at STANDBY? Will dataguard get confused about it?

       

      Please helpppppppppp.....

       

      Thanks

        • 1. Re: Gaps exists again
          mseberg

          Hello;

           

          What does the alert log on the Standby side say?

           

          Exactly what log is it waiting for?

           

           

          Best Regards

           

          mseberg

          • 2. Re: Gaps exists again

            Hi Mse,

             

            I only see lots of these at STANDBY alert log:

             

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:00:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:01:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:02:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:03:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:04:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:05:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:06:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:07:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:08:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:09:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:10:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:11:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:12:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:13:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            Mon Mar 10 20:14:58 2014

            Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

            • 3. Re: Gaps exists again

              But if I run tha gap sql script, I got this:

               

              PROD      PROD-SVR            5210        5161  09-MAR/12:38         49  (gaps)

              • 4. Re: Gaps exists again
                mseberg

                Hello again

                 

                STANDBY_ARCHIVE_DEST parameter is deprecated that why you are seeing that.

                 

                What I'm trying to determine is if you have a gap for a large "Lag"

                 

                I'm looking for a message like this:

                 

                Media Recovery Waiting for thread 1 sequence 1709 (in transit)

                 

                Best Regards

                 

                mseberg

                • 5. Re: Gaps exists again

                  Hayyy naku....I have lots of untransferred logs starting from 5162 which is missing. My question is, can  I lump all the missing logs in 1 folder? Since the folder contents for PRIMARY and SECONDARY are not SYNC anymore. I do not know which one belongs to what folder

                  • 6. Re: Gaps exists again
                    mseberg

                    You can copy say SCP them to the Standby and register them there.

                     

                    The:

                     

                    ALTER DATABASE REGISTER LOGFILE

                     

                    Which account for whatever folder you put them in.

                     

                    My concern is you might have a lag and you could be helping oracle too much in that event.

                     

                    Any chance your FRA is full on the Standby side?

                     

                    Best Regards

                     

                    mseberg

                    • 7. Re: Gaps exists again

                      No its not full. My misery started when the firewall database was corrupted. In which everything unable to connect to anywhere. some mapping were lots. Even now if I login to the DR site the cursor response is delayed. I tried to FTP a file and it its speed is only 10/kbps. So how can you expect a 100Mb archivelog size to be completed

                      • 8. Re: Gaps exists again
                        BPeaslandDBA

                        f55237a7-2c38-4db3-a7a3-1d77256f0730 wrote:

                         

                        Hayyy naku....I have lots of untransferred logs starting from 5162 which is missing. My question is, can  I lump all the missing logs in 1 folder? Since the folder contents for PRIMARY and SECONDARY are not SYNC anymore. I do not know which one belongs to what folder

                         

                        Yes, you can lump them all in one folder. What I often do when I need to manually ship lots of logs to the standby is that I put them in a separate folder, away from the regular archive logs on the standby db server. Then after I get the logs there, I register them with the standby. I often find that for lots of missing logs, this is faster than letting FAL get the logs for me.

                         

                        Cheers,

                        Brian

                        • 9. Re: Gaps exists again
                          mseberg

                          OK.

                           

                          Like I said this command "ALTER DATABASE REGISTER LOGFILE" will account for wherever you put them.

                           

                          Best Regards

                           

                          mseberg

                          • 10. Re: Gaps exists again
                            mohith2009

                            Whats the lag difference you have..How many archivelog need to be applied.

                            • 11. Re: Gaps exists again

                              Thanks all,

                               

                              46 logs need to be applied. but 80% are already on the regulat forlder on 20% are missing gaps in between. So should I lump them on the same folder not separating by dates?

                               

                               

                              Thanks

                              • 12. Re: Gaps exists again

                                Hi all,

                                 

                                Re: register logfile.

                                 

                                What happens if I register a new logfile '/u01/ARCH'   and I copied archivelogs  with has duplicate from the FRA/archivelog, is this okay?

                                 

                                 

                                Thanks

                                • 13. Re: Gaps exists again

                                  Helloooooooo

                                  • 14. Re: Gaps exists again

                                    Hi all,

                                     

                                    I tried this on our standby:

                                    1 2 3 Previous Next