Hi,
I am working on Oracle 10.2.0.4 version on Solaris 9. I am using ASM for storage.
I have a DG setup, which i wanted to have one primary and 2 physical standby databases in MAX AVAILABILITY & MAX PERFORMANCE mode respecitively. I successfully setup the DG environment but would like to know if there is any type of verification or views that show that what standby is performing in what mode(v$dataguard_status,v$managed_standby, etc).
I have used the following log_archive_dest_n on the primary database entries for enabling the protection modes.
log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=testdb_1
log_archive_dest_2 SERVICE=testdb_2 OPTIONAL LGWR SYNC AFFIRM VALID_FOR=
(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testdb_2
log_archive_dest_3 SERVICE=testdb_3 OPTIONAL ARCH ASYNC AFFIRM VALID_FOR=
(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testdb_3
I want to put
1) testdb_2 standby in MAXIMUM AVAILABILITY
2) testdb_3 standby in MAXIMUM PERFORMANCE
I built the testdb_2 physical standby first and upgraded the protection mode to MAXIMUM AVAILABILITY and is working fine (this is using real time log apply).
I built the testdb_3 phyisical standby second and just started the redo apply using "alter database recover managed standby database disconnect from session).
The whole DG setup is working fine with applying logs. But my main question is that when i give "select protection_mode, protection_level from v$database" on primary database, it shows only the "MAXIMUM AVAILABILITY" mode. Where do i see that MAXIMUM PERFORMANCE mode is existing too for this DG environment? Is there any view or do we just confirm this by seeing the managed recovery processes in the v$managed_standby view?
Any information or documentation links would be greatly appreciated.
Thanks,
Harris