This post is more than 5 years old
2 Intern
•
643 Posts
0
2627
April 26th, 2012 23:00
Oracle Data Guard Architecture for Multiple Standby Database
In case I am setting up an Oracle Data Guard system which requests multiple standby database copies. What is the maximum number of standby copies can be supported by the primary database from performance consideration? What is the best practice if I need multiple standby copies, for example 8?
No Events found!
zhaos2
2 Intern
•
643 Posts
0
May 14th, 2012 22:00
Thanks Betty for your research!
Maximum performance protection mode (the default) will allow a transaction to commit as soon as the redo data needed to recover that transaction is written to the local online redo log. The primary database's redo data stream is also written to at least one standby database, but that redo stream is written asynchronously with respect to the transactions that create the redo data. So the primary database performance impact is minimized.