Change standby database Protection mode

         Convert MAXIMUM PERFORMANCE to MAXIMUM AVAILABILITY

On Primary DB

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
OPEN         KANDY            PRIMARY          MAXIMUM PERFORMANCE


* Number of standby and online redo logs and it’s sizes should be same

SQL> select group#,bytes/1024/1024 from v$log;

    GROUP# BYTES/1024/1024
---------- ---------------
         1              50
         2              50
         3              50

SQL> select group#,bytes/1024/1024 from v$standby_log;

    GROUP# BYTES/1024/1024
---------- ---------------
         4              50
         5              50
         6              50


SQL> select thread#,max(sequence#) from v$archived_log group by thread#;

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1             49

ON STANDBY DB

SQL> select thread#,max(sequence#) from v$archived_log group by thread#;

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1             49

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
MOUNTED      COLOMBO          PHYSICAL STANDBY MAXIMUM PERFORMANCE


ON PRIME DB

Configure to use SYNCHRONOUS mode

SQL> select value from v$parameter where name='log_archive_dest_2';

VALUE
--------------------------------------------------------------------------------
service=TNS_COL LGWR ASYNC NOAFFIRM max_failure=10 max_connections=5 reopen=180
valid_for=(online_logfiles,primary_role) db_unique_name=colombo

alter system set log_archive_dest_2='service="TNS_COL" LGWR AFFIRM SYNC db_unique_name="colombo" valid_for=(all_logfiles,primary_role)';
alter database set standby database to maximize availability;
select status,instance_name,database_role,protection_mode from v$database,v$instance;

SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance;

STATUS       INSTANCE_NAME    DATABASE_ROLE    PROTECTION_MODE
------------ ---------------- ---------------- --------------------
OPEN         KANDY            PRIMARY          MAXIMUM AVAILABILITY

-----------------------------

If you have configured broker , change the below parameter

edit database 'colombo' SET PROPERTY LogXptMode='SYNC';