This discussion is archived
3 Replies Latest reply: Nov 11, 2012 8:49 PM by Satishbabu Gunukula RSS

update statement  works in oracle RAC

778369 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points