Hi ,
Primary : crms
Standby : stbycrms
On standby server , log_archive_dest_state_2 is changed to ENABLE automatically. ( which points primary server)
I tried many times to solve the issue. no improvement.
I think DGMGRL is changing the value of the parameter log_archive_dest_state_2 = ENABLE
How can solve it ? is this bug in 11.2.0.1 ?
SQL> select db_unique_name, open_mode, database_role, switchover_status from v$database;
DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------------------------ -------------------- ---------------- --------------------
crms READ WRITE PRIMARY TO STANDBY
SQL> select thread#, max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 2018
SQL> select db_unique_name, open_mode, database_role, switchover_status from v$database;
DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------------------------ -------------------- ---------------- --------------------
stbycrms READ ONLY WITH APPLY PHYSICAL STANDBY NOT ALLOWED
SQL> select thread#, max(sequence#) from v$archived_log where applied='YES' group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 2018
DGMGRL>
Configuration - dgcrms
Protection Mode: MaxPerformance
Databases:
stbycrms - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
crms - Physical standby database
Error: ORA-16810: multiple errors or warnings detected for the database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
>> On Standby server
SQL> show parameter log_archive_dest_state_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string ENABLE
SQL> alter system set log_archive_dest_state_2='DEFER' scope=both;
System altered.
SQL> startup force;
...
Database opened.
SQL> show parameter log_archive_dest_state_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string ENABLE
SQL> show parameter log_archive_dest_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service="crmsdb", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0
max_connections=1 reopen=300 db _unique_name="crms" net_timeout=30, valid_for=(all_logfiles, primary_role)
Thanks.
Any solution without removing configuration file of DGMGRL. ??