7 Replies Latest reply: Feb 9, 2014 7:19 PM by 816889 RSS

    Data Pump with dataguard ON

    816889

      Hi,

       

      We have got a primary and standby system (Data guard).

       

      The Primary database is refreshed with a Data pump from another DB every weekend and it takes 4 Hours.

       

      The Data Guard and the standby are stopped as it takes a lot of time for the import with the dataguard and the standby on(more than 9 hours).

       

      Please let me know the best possible way to do the data pump and also at a lesser time cost.

        • 1. Re: Data Pump with dataguard ON
          CKPT

          Hi,

           

          what is the version you are using? Its been a good question.

          what is the protection mode?

           

          When import process is going on primary, why you need to stop standby ? When import operations going same times there will be huge redo will be generated and of course they will be transmitted to standby destination. If you stop Data Guard then there will be lot of LAG between two sites.

           

          Do you have good bandwidth speed or what issues they are to take 9 hours of time when the import process is just 4 hours?

          If you are using 11.x then it supports compression of redo and it can helps you in case of network bandwidth is low, again compressesion is extra license option.

          But what i can say is, you no need to stop Data Guard when import process is going on.

          • 2. Re: Data Pump with dataguard ON
            mseberg

            Hello;

             

            The whole database is refreshed or is just part of it refreshed? Can you explain the function of the database? Is it used or reporting for example?

             

            As CKPT said the redo will be huge so maybe the solution is to avoid the import on a Data Guard system.

             

            Best Regards

             

            mseberg

            • 3. Re: Data Pump with dataguard ON
              816889

              Hi,

               

              PFB , the details

               

              DB version - 11.2.0.2

              Full protection Mode.

               

              When the import goes to the primary, there are a lot of redo files been generated and to transmit those files to the standby takes a lotof time. Hence the overall process takes a lot of time.

               

              The Whole database is refreshed.

               

              Regards,

              Suresh


              • 4. Re: Data Pump with dataguard ON
                mseberg

                Hello again;

                 

                If "Whole database is refreshed." then you are already working with a copy. Why use Data Guard on a copy of another database?

                 

                Is there something you forgot to tell us?

                 

                Best Regards

                 

                mseberg

                • 5. Re: Data Pump with dataguard ON
                  Renu-Oracle

                  Hi,

                   

                  Please confirm what is the purpose of refreshing the standby daily.

                   

                  Thanks,

                  • 6. Re: Data Pump with dataguard ON
                    CKPT

                    816889 wrote:

                     

                    Hi,

                     

                    PFB , the details

                     

                    DB version - 11.2.0.2

                    Full protection Mode.

                     

                    When the import goes to the primary, there are a lot of redo files been generated and to transmit those files to the standby takes a lotof time. Hence the overall process takes a lot of time.

                     

                    The Whole database is refreshed.

                     

                    Regards,

                    Suresh

                     

                     

                    I dont think it is protection method, because you said data guard will be stopped during the process of import, Its not possible in Maximum protection mode and both primary and standby database(s) should be available to send redo synchronously.

                     

                    Whatever, here is my two cents when you refersh in huge size.

                     

                    1) Either change protection mode from maximum protection to maximum performance (when you refresh)

                     

                    or

                     

                    2) Perform refresh periodically, like small amount of transactions.. Because Maximum protection bahaviour (SYNC AFFIRM) where the redo has to be written on standby and then with the acknowledgement it also writes in online redo logs, in case of any network latency or any issues on standby then of course your primary database hangs.

                    • 7. Re: Data Pump with dataguard ON
                      816889

                      Hi mseberg,

                       

                      The company has been acquired. So the data comes in from the parent company and there are couple of other processes/interfaces that runs and updates the system after the import. so the entire architecture (Primary and standby) is used as a standby system.

                       

                      Thnx CKPT. Will try the maximum performance mode and update.

                      Regards,

                      Suresh S