3 Replies Latest reply: Nov 11, 2012 10:49 PM by Satishbabu Gunukula RSS

    update statement  works in oracle RAC

    778369
      Hi Experts,


      How the update statement works in oracle RAC environment.
      And why we need a separate redo for each instance what will happen if we wont give.

      Regrds
      Suneel
        • 1. Re: update statement  works in oracle RAC
          sb92075
          user1175505 wrote:
          Hi Experts,


          How the update statement works in oracle RAC environment.
          UPDATE does not know or care if it on RAC or single instance.
          And why we need a separate redo for each instance what will happen if we wont give.
          you can't start Oracle DB without any REDO.

          Handle:     user1175505
          Status Level:     Newbie
          Registered:     Jun 9, 2010
          Total Posts:     610
          Total Questions:     249 (182 unresolved)

          WOW! Why do you waste your time here when you rarely get answers to your questions?
          • 2. Re: update statement  works in oracle RAC
            Helios-GunesEROL
            Hi Suneel;

            How the update statement works in oracle RAC environment.
            As mention here you dont need to care your update run on rac or standalone.
            And why we need a separate redo for each instance what will happen if we wont give.
            This issue related wiht RAC instance, In rac system each node have their redlogfiles

            Regard
            Helios
            • 3. Re: update statement  works in oracle RAC
              Satishbabu Gunukula
              As others said, there is no difference. It looks like you didnt explain your doubt/issue clearly.
              In RAC, two different instances running on two different nodes, so you need seperate set of redo in order to manage.

              Please be clear with your question, so that you will get right answer.

              Regards,
              http://www.oracleracexpert.com
              RMAN Debug and Trace
              http://www.oracleracexpert.com/2012/11/rman-debug-and-trace.html
              Time for Change: Migrate your Non-RAC Database to RAC
              http://www.oracleracexpert.com/2012/10/time-for-change-migrate-your-non-rac.html