This content has been marked as final. Show 1 reply
I need to add 2 more standby databases (physical) in ASYNC mode.its depends on several things
Does anyone have any performance metrics on primary db performance when adding extra standby databases.
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).if you are using cascading standby db, then the workload of redo transport will be off the primary.
Where will the bottleneck be ..... if any...
BUT "Cascaded Redo Transport Destinations... Releases prior to 220.127.116.11 have several limitations for this feature that are not present in release 18.104.22.168."