5 Replies Latest reply: Jan 14, 2014 4:44 AM by mseberg RSS

    Dataguard setup

      Hi All,

       

      11.2.0.3

      Aix 6.1

       

      We have PROD server (with PSU 11.2.0.3.5) which is cloned to another Test Server. The purpose of this Test Server is to apply (PSU 11.2.0.3.8) and test if our prod app will run smoothly and have no issues.

      If successful, then we will patch the PROD server to 11.2.0.3.8.

       

      My question is can I setup dataguard from 11.2.0.3.5  (PROD) to  the Test Server (11.2.0.3.8)?

       

       

      Thanks a lot,

      pK

        • 1. Re: Dataguard setup
          mseberg

          Hello;

           

          No. They should be the exact same version. It's as simple as that.

           

          Best Regards

           

          mseberg

          • 2. Re: Dataguard setup

            Ouch! and to think this is the priority task I can not do the DG setup now? I already patch the target to 11.2.0.3.8 PSU

             

            So how can you patch an existing DG if the have to be of the same patch? Its ironic right? Eventually you have to patch the primary. So they wont be the same anymore at one point in time.

             

            Thanks,

            • 3. Re: Dataguard setup
              mseberg

              Hello again;

               

              Is it possible to move to 11.2.0.4?

               

              Best Regards

               

              mseberg

              • 4. Re: Dataguard setup

                Thanks mse

                 

                What is the advantage of moving to 11.2.0.4?

                 

                By the way....we have also 9i database. Is dataguard on 9i can be open in read-only mode to?

                • 5. Re: Dataguard setup
                  mseberg

                  "What is the advantage of moving to 11.2.0.4"

                   

                  For one you will be ready for the next quarterly patch from Oracle. Plus if you ever open a support ticket you would be current with Oracle 11 thus avoiding the whole upgrade and see if that fixes it thing.

                   

                  I don't know the answer to your Oracle 9 question, but I'm thinking no.

                   

                  Best Regards

                   

                  mseberg