This discussion is archived
1 Reply Latest reply: Apr 12, 2013 8:53 AM by teits RSS

10g Primary Performace - extra physical standbys

574843 Newbie
Currently Being Moderated
Hi
I have a 10g 3 node RAC primary db to a 3 node RAC standby (physical) db. (in SYNC mode delay = 0)
The SLA for the app is extremely tight.

I need to add 2 more standby databases (physical) in ASYNC mode.

Does anyone have any performance metrics on primary db performance when adding extra standby databases.

There is an oracle node about cascading standby db's in RAC environment (which suggests you shouldn't due to different redo streams).

Where will the bottleneck be ..... if any...
  • 1. Re: 10g Primary Performace - extra physical standbys
    teits Journeyer
    Currently Being Moderated
    hello,

    I need to add 2 more standby databases (physical) in ASYNC mode.

    Does anyone have any performance metrics on primary db performance when adding extra standby databases.
    its depends on several things
    1. on the workload vs the cpu, memory,storage performance
    2. the size of your database
    3. network performance
    4. if you have recent backup, will reduce the time and impact on primary db
    There is an oracle node about cascading standby db's in RAC environment (which suggests you shouldn't due to different redo streams).

    Where will the bottleneck be ..... if any...
    if you are using cascading standby db, then the workload of redo transport will be off the primary.
    BUT "Cascaded Redo Transport Destinations... Releases prior to 11.2.0.2 have several limitations for this feature that are not present in release 11.2.0.2."


    Tobi
    HTH

Legend

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