This content has been marked as final. Show 7 replies
If you want "Data Guard Setup on Oracle 11 Step by Step"
If you want "Data Guard Cascading Standby Setup and Test"
thanks for the steps. but i want to know maximum how many standby database we create for a Production database.
Depends on your release. Theoretically, 30 with 11g.1 person found this helpful
SQL> show parameter log_archive_dest
For 10g Release 2 i think we can create 9 standby database for a primary database.
I see what you mean. Checking for supporting document.
Table 13–1 (Cont.) Initialization Parameters for Instances in a Data Guard Configuration
Data Guard Concepts and Administration 10g Release 2 (10.2) B14239-05
Required. Define up to ten (where n = 1, 2, 3, ... 10) destinations, each of which must specify either the LOCATION or SERVICE attribute.
Edited by: mseberg on Nov 7, 2012 9:12 AM