0 Replies Latest reply on Jun 14, 2019 4:13 PM by 3721483

    SWITCHOVER to standby fails on 18c in ADG configuration

    3721483

      Hi

      We just upgraded several 11204 databases to 18c(18.6.0.0) and built the standby databases. What we observed is that the SWITCHOVER is working when the standby is in Mount mode and not working when it is ADG(Active Dataguard).

      I am running in to "ORA-03816: Message 3816 not found;  product=RDBMS; facility=ORA"

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      DGMGRL gives this:

      GMGRL> switchover to FSDEV92_DG4

      Performing switchover NOW, please wait...

      Operation requires a connection to database "fsdev92_dg4"

      Connecting ...

      Connected to "FSDEV92_DG4"

      Connected as SYSDBA.

      Error: ORA-312: online log  thread : ''

       

      Failed.

      Unable to switchover, primary database is still "fsdev92_dg3"

       

      Primary's alert log says:

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      RSM0 (PID:9693): Active, synchronized Physical Standby switchover target has been identified

      RSM0 (PID:9693): Preventing updates and queries at the Primary

      2019-06-14T11:49:18.157451-04:00

      Errors in file /data01/app/oracle/diag/rdbms/fsdev92_dg3/FSDEV92_DG3/trace/FSDEV92_DG3_tt00_9790.trc:

      ORA-03816: Message 3816 not found;  product=RDBMS; facility=ORA

      2019-06-14T11:49:18.157513-04:00

      TT00 (PID:9790): krsg_check_connection: Error 3816 connecting to standby 'FSDEV92_DG4'

      2019-06-14T11:49:18.356028-04:00

      Errors in file /data01/app/oracle/diag/rdbms/fsdev92_dg3/FSDEV92_DG3/trace/FSDEV92_DG3_tt00_9790.trc:

      ORA-03816: Message 3816 not found;  product=RDBMS; facility=ORA

      TT00 (PID:9790): krsg_check_connection: Error 3816 connecting to standby 'FSDEV92_DG4'

      2019-06-14T11:49:18.956694-04:00

      RSM0 (PID:9693): Generating and shipping final logs to target standby

      Switchover End-Of-Redo Log thread 1 sequence 5833 has been fixed

      Switchover: Primary highest seen SCN set to 0x000000352f561360

      RSM0 (PID:9693): Noswitch archival of T-1.S-5833

      RSM0 (PID:9693): End-Of-Redo Branch archival of T-1.S-5833

      RSM0 (PID:9693): LGWR is actively archiving to LAD:2

      2019-06-14T11:49:19.185970-04:00

      Errors in file /data01/app/oracle/diag/rdbms/fsdev92_dg3/FSDEV92_DG3/trace/FSDEV92_DG3_rsm0_9693.trc:

      ORA-03816: Message 3816 not found;  product=RDBMS; facility=ORA

      RSM0 (PID:9693): Error 3816 Creating archive log file to 'FSDEV92_DG4'

      Switchover to standby failed with error 16038

      ORA-16455 signalled during: ALTER DATABASE SWITCHOVER TO 'fsdev92_dg4'...

      2019-06-14T11:49:56.026620-04:00

      Process (ospid 8218) is suspended due to switchover to physical standby operation.

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      And leaves the PRIMARY in this state:

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

      INSTANCE_NAME    OPEN_MODE            DATABASE_ROLE

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

      FSDEV92_DG3      CLOSED BY SWITCHOVER PRIMARY

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      Any help is appreciated