Tracing DGMRL Switchover Activity.
Synatx : dgmgrl -debug sys/abc#123@lapprimdb
[oraprd@prd1 STANDBY]$ dgmgrl -debug sys/abc#123@lapprimdb
Created directory /oracle/PRD/19/dataguard
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Jun 1 21:59:02 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
[W000 2021-06-01T21:59:02.431-05:00] Connecting to database using lapprimdb.
[W000 2021-06-01T21:59:02.431-05:00] Attempt logon as SYSDBA
[W000 2021-06-01T21:59:02.456-05:00] Successfully logged on as SYSDBA
[W000 2021-06-01T21:59:02.456-05:00] Executing query [select sys_context('USERENV','CON_ID') from dual].
[W000 2021-06-01T21:59:02.458-05:00] Query result is '0'
[W000 2021-06-01T21:59:02.458-05:00] Executing query [select value from v$parameter where name = 'db_unique_name'].
[W000 2021-06-01T21:59:02.464-05:00] Query result is 'LAPPRIMDB'
Connected to "LAPPRIMDB"
[W000 2021-06-01T21:59:02.464-05:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 2021-06-01T21:59:02.471-05:00] Oracle database version is '19.8.0.0.0'
Connected as SYSDBA.
DGMGRL> validate database lapdrdb;
[W000 2021-06-01T21:59:08.097-05:00] <DO_MONITOR version="19.1"><PROPERTY name="RoleChangeReadiness" object_id="33619968"/></DO_MONITOR>
[W000 2021-06-01T21:59:08.207-05:00] <TABLE name="ROLE CHANGE READINESS"><DESCRIPTION ><COLUMN name="KEY" type="string" max_length="40"></COLUMN><COLUMN name="REQUIRED" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_1" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_2" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_3" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_4" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_5" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_6" type="string" max_length="40"></COLUMN><COLUMN name="VALUE_7" type="string" max_length="40"></COLUMN></DESCRIPTION><TR ><TD >ORL_SRL_INFO</TD><TD >YES</TD><TD >1</TD><TD >3</TD><TD >3</TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >ACTIVE_REDOSOURCE_INFO</TD><TD >YES</TD><TD >LAPPRIMDB</TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >REDO DESTINATION</TD><TD >YES</TD><TD >lapdrdb</TD><TD >LAPPRIMDB</TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >DB_CONFIGURATION</TD><TD >YES</TD><TD >MaxPerformance</TD><TD >YES</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >PHYSICAL</TD><TD >YES</TD><TD ></TD></TR><TR ><TD >CAPACITY_INFO</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >1</TD><TD >1</TD><TD >lapdrdb</TD><TD >1</TD><TD >1</TD><TD >NO</TD></TR><TR ><TD >CLUSTERWARE_MANAGED</TD><TD >YES</TD><TD >LAPPRIMDB</TD><TD >NO</TD><TD >lapdrdb</TD><TD >NO</TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >APPLY_INFO</TD><TD >YES</TD><TD >RUNNING</TD><TD >UNKNOWN</TD><TD >4294967295</TD><TD >0</TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >TEMP_FILES</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >1</TD><TD >lapdrdb</TD><TD >1</TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >FLASHBACK_ON</TD><TD >YES</TD><TD >LAPPRIMDB</TD><TD >OFF</TD><TD >lapdrdb</TD><TD >OFF</TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >ONLINE_MOVE</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >NO</TD><TD >lapdrdb</TD><TD >NO</TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >TRANSPORT_INFO</TD><TD >NO</TD><TD >YES</TD><TD >NO_GAP</TD><TD >0</TD><TD >0</TD><TD >0</TD><TD ></TD><TD ></TD></TR><TR ><TD >ORL_SRL_CHECK_CURRENT</TD><TD >YES</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >1</TD><TD >3</TD><TD >3</TD><TD ></TD><TD ></TD></TR><TR ><TD >SRL_TOO_SMALL_CURRENT_STANDBY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >1</TD><TD >200</TD><TD >MBytes</TD><TD >200</TD><TD >MBytes</TD></TR><TR ><TD >ORL_SRL_CHECK_FUTURE</TD><TD >YES</TD><TD >lapdrdb</TD><TD >LAPPRIMDB</TD><TD >1</TD><TD >3</TD><TD >2</TD><TD ></TD><TD ></TD></TR><TR ><TD >SRL_TOO_SMALL_FUTURE_STANDBY</TD><TD >NO</TD><TD >lapdrdb</TD><TD >LAPPRIMDB</TD><TD >1</TD><TD >200</TD><TD >MBytes</TD><TD >200</TD><TD >MBytes</TD></TR><TR ><TD >LOG_FILES_CLEARED</TD><TD >YES</TD><TD >LAPPRIMDB</TD><TD >YES</TD><TD >lapdrdb</TD><TD >NO</TD><TD >YES</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >LogShipping</TD><TD >ON</TD><TD >ON</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >LogXptMode</TD><TD >ASYNC</TD><TD >ASYNC</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >Dependency</TD><TD ></TD><TD ></TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >DelayMins</TD><TD >0</TD><TD >0</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >Binding</TD><TD >optional</TD><TD >OPTIONAL</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >MaxFailure</TD><TD >0</TD><TD >0</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >ReopenSecs</TD><TD >300</TD><TD >300</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >NetTimeout</TD><TD >30</TD><TD >30</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_TRANSPORT_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >RedoCompression</TD><TD >DISABLE</TD><TD >DISABLE</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_APPLY_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >DelayMins</TD><TD >0</TD><TD >0</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_APPLY_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >ApplyParallel</TD><TD >AUTO</TD><TD >AUTO</TD><TD ></TD><TD ></TD></TR><TR ><TD >INCONSISTENT_APPLY_PROPERTY</TD><TD >NO</TD><TD >LAPPRIMDB</TD><TD >lapdrdb</TD><TD >ApplyInstances</TD><TD >0</TD><TD >0</TD><TD ></TD><TD ></TD></TR><TR ><TD >READY_FOR_ROLE_CHANGE</TD><TD >YES</TD><TD >YES</TD><TD >YES</TD><TD >NO</TD><TD >YES</TD><TD >YES</TD><TD ></TD><TD ></TD></TR></TABLE>
Database Role: Physical standby database
Primary Database: LAPPRIMDB
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Flashback Database Status:
LAPPRIMDB: Off
lapdrdb : Off
Managed by Clusterware:
LAPPRIMDB: NO
lapdrdb : NO
[W000 2021-06-01T21:59:08.210-05:00] <DO_MONITOR version="19.1"><PROPERTY name="StaticConnectIdentifier" object_id="16777216"/></DO_MONITOR>
[W000 2021-06-01T21:59:08.212-05:00] <VALUE object_id="16777216" property_name="StaticConnectIdentifier" value_type="string" value="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED)))" subtype="8456198" property_type="configuration"></VALUE>
Validating static connect identifier for the primary database LAPPRIMDB...
[W000 2021-06-01T21:59:08.213-05:00] Connecting to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE))).
[W000 2021-06-01T21:59:08.213-05:00] Attempt logon as SYSDBA
[W000 2021-06-01T21:59:08.242-05:00] Successfully logged on as SYSDBA
[W000 2021-06-01T21:59:08.242-05:00] Executing query [select sys_context('USERENV','CON_ID') from dual].
[W000 2021-06-01T21:59:08.243-05:00] Query result is '0'
[W000 2021-06-01T21:59:08.243-05:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 2021-06-01T21:59:08.243-05:00] Oracle database version is '19.8.0.0.0'
The static connect identifier allows for a connection to database "LAPPRIMDB".
Standby Apply-Related Information:
Apply State: Running
Apply Lag: Unknown
Apply Delay: 0 minutes
Log Files Cleared:
LAPPRIMDB Standby Redo Log Files: Cleared
lapdrdb Online Redo Log Files: Not Cleared
lapdrdb Standby Redo Log Files: Available
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(LAPPRIMDB) (lapdrdb)
1 3 3 Insufficient SRLs
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(lapdrdb) (LAPPRIMDB)
1 3 2 Insufficient SRLs
DGMGRL> switchover to lapdrdb;
[W000 2021-06-01T21:59:15.312-05:00] <DO_MONITOR version="19.1"><VERIFY object_id="4096" level="minor"/></DO_MONITOR>
[W000 2021-06-01T21:59:15.328-05:00] <RESULT ><MESSAGE ><SUCCESS ></SUCCESS></MESSAGE><MESSAGE ><SUCCESS ></SUCCESS></MESSAGE></RESULT>
Performing switchover NOW, please wait...
[W000 2021-06-01T21:59:15.333-05:00] <DO_CONTROL version="19.1"><DO_MOVE type="Switchover" site_id="33554432"/></DO_CONTROL>
[W000 2021-06-01T21:59:15.427-05:00] <TABLE name="DG BROKER CLIENT OPERATION LIST"><DESCRIPTION ><COLUMN name="OPERATION" type="string" max_length="20"></COLUMN><COLUMN name="INSTANCE_ID" type="integer" max_length="30"></COLUMN><COLUMN name="CONNECT" type="string" max_length="4095"></COLUMN></DESCRIPTION><TR ><TD >REDIRECT</TD><TD >33619969</TD><TD >lapdrdb</TD></TR></TABLE>
Operation requires a connection to database "lapdrdb"
Connecting ...
[W000 2021-06-01T21:59:15.429-05:00] Connecting to database using lapdrdb.
[W000 2021-06-01T21:59:15.429-05:00] Attempt logon as SYSDBA
[W000 2021-06-01T21:59:15.458-05:00] Successfully logged on as SYSDBA
[W000 2021-06-01T21:59:15.458-05:00] Executing query [select sys_context('USERENV','CON_ID') from dual].
[W000 2021-06-01T21:59:15.459-05:00] Query result is '0'
[W000 2021-06-01T21:59:15.459-05:00] Executing query [select value from v$parameter where name = 'db_unique_name'].
[W000 2021-06-01T21:59:15.465-05:00] Query result is 'LAPDRDB'
Connected to "LAPDRDB"
[W000 2021-06-01T21:59:15.465-05:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 2021-06-01T21:59:15.466-05:00] Oracle database version is '19.8.0.0.0'
Connected as SYSDBA.
[W000 2021-06-01T21:59:15.466-05:00] <DO_CONTROL version="19.1"><DO_MOVE type="Switchover" site_id="33554432"/></DO_CONTROL>
[W000 2021-06-01T21:59:27.987-05:00] <TABLE name="DG BROKER CLIENT OPERATION LIST"><DESCRIPTION ><COLUMN name="OPERATION" type="string" max_length="20"></COLUMN><COLUMN name="INSTANCE_ID" type="integer" max_length="30"></COLUMN><COLUMN name="CONNECT" type="string" max_length="4095"></COLUMN></DESCRIPTION><TR ><TD >OPENING</TD><TD >33619969</TD><TD >(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd2.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPDRDB_DGMGRL)(INSTANCE_NAME=LAPDRDB)(SERVER=DEDICATED)))</TD></TR><TR ><TD >STARTUP MOUNT</TD><TD >16842753</TD><TD >(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED)))</TD></TR></TABLE>
New primary database "lapdrdb" is opening...
Operation requires start up of instance "LAPPRIMDB" on database "LAPPRIMDB"
Starting instance "LAPPRIMDB"...
[W000 2021-06-01T21:59:30.990-05:00] Connecting to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED))).
[W000 2021-06-01T21:59:30.990-05:00] Attempt logon as SYSDBA
[W000 2021-06-01T21:59:32.034-05:00] Successfully logged on as SYSDBA using PRELIM_AUTH
Connected to an idle instance.
ORACLE instance started.
[W000 2021-06-01T21:59:44.115-05:00] Connecting to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED))).
[W000 2021-06-01T21:59:44.115-05:00] Attempt logon as SYSDBA
[W000 2021-06-01T21:59:44.146-05:00] Successfully logged on as SYSDBA
[W000 2021-06-01T21:59:44.146-05:00] Executing query [select sys_context('USERENV','CON_ID') from dual].
[W000 2021-06-01T21:59:44.148-05:00] Query result is '0'
[W000 2021-06-01T21:59:44.148-05:00] Executing query [select value from v$parameter where name = 'db_unique_name'].
[W000 2021-06-01T21:59:44.157-05:00] Query result is 'LAPPRIMDB'
Connected to "LAPPRIMDB"
[W000 2021-06-01T21:59:44.157-05:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 2021-06-01T21:59:44.159-05:00] Oracle database version is '19.8.0.0.0'
[W000 2021-06-01T21:59:44.159-05:00] Executing statement [alter database mount].
[W000 2021-06-01T21:59:48.297-05:00] Statement [alter database mount] executed successfully.
Database mounted.
[W000 2021-06-01T21:59:48.297-05:00] Checking for bootstrap done...
[W000 2021-06-01T21:59:48.298-05:00] Connecting to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd1.hana.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=LAPPRIMDB_DGMGRL)(INSTANCE_NAME=LAPPRIMDB)(SERVER=DEDICATED))).
[W000 2021-06-01T21:59:48.298-05:00] Attempt logon as SYSDBA
[W000 2021-06-01T21:59:48.322-05:00] Successfully logged on as SYSDBA
[W000 2021-06-01T21:59:48.322-05:00] Executing query [select sys_context('USERENV','CON_ID') from dual].
[W000 2021-06-01T21:59:48.323-05:00] Query result is '0'
[W000 2021-06-01T21:59:48.323-05:00] Executing query [select value from v$parameter where name = 'db_unique_name'].
[W000 2021-06-01T21:59:48.329-05:00] Query result is 'LAPPRIMDB'
Connected to "LAPPRIMDB"
[W000 2021-06-01T21:59:48.329-05:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 2021-06-01T21:59:48.331-05:00] Oracle database version is '19.8.0.0.0'
[W000 2021-06-01T22:00:03.339-05:00] Done waiting for bootstrap after 0 retries
Switchover succeeded, new primary is "lapdrdb"
DGMGRL>
