Description:-
These are the changes in Oracle Data Guard Broker in Oracle Database Release 18c
This release provides several new commands:
- VALIDATE DATABASE SPFILE performs a comparison of server parameter file (SPFILE) entries between the primary database and a specified standby database.
- VALIDATE NETWORK CONFIGURATION performs network connectivity checks between members of a broker configuration.
- VALIDATE STATIC CONNECT IDENTIFIER validates the static connect identifier of a database.
- SET ECHO controls whether or not to echo commands that are issued either at the command-line prompt or from a DGMGRL script.
- SHOW ALL (DGMGRL CLI properties) shows the values of DGMGRL CLI properties.
The V$DATAGUARD_PROCESS view, introduced in Oracle Database 12c Release 2 (12.2.0.1), now shows broker processes. (Oracle Data Guard Monitor (DMON)
Process.)
SQL> select name,TYPE,role from V$DATAGUARD_PROCESS; NAME TYP ROLE ----- --- ------------------------ LGWR KSB log writer TMON KSB redo transport monitor DMON KSB broker monitor INSV KSB broker instance slave NSV2 KSB broker net slave TT00 KSV gap manager TT01 KSV redo transport timer ARC0 KSB archive local TT02 KSV async ORL multi TT03 KSV heartbeat redo informer ARC1 KSB archive redo ARC2 KSB archive redo ARC3 KSB archive redo RSM0 KSB broker worker drcx NET switchover 15 rows selected.
VALIDATE DATABASE SPFILE
The VALIDATE DATABASE SPFILE command performs a comparison of server parameter file (SPFILE) entries between the primary database and a specified standby database.
The validation of the server parameter file detects parameter value discrepancies between the primary and the specified standby database so that they can be rectified before a role change, thus ensuring that after a role change the databases perform at the same level they did prior to the role change. Additionally, using this command frees you from having to restart a database to correct improperly set parameters.
Format
VALIDATE DATABASE {database-name} SPFILE;
If the database to be validated is the primary database, then a message is returned saying the command cannot be issued on a primary database.
DGMGRL> VALIDATE DATABASE dbwrprim SPFILE; This command cannot be used for the primary database.
DGMGRL> VALIDATE DATABASE dbwrstby SPFILE;
Connecting to "dbwrprim".
Connected to "dbwrprim"
Connecting to "dbwrstby".
Connected to "dbwrstby"
Parameter settings with different values:
audit_file_dest:
dbwrprim (PRIMARY) : /oradb/app/oracle/admin/dbwrprim/adump
dbwrstby : /oradb/app/oracle/admin/dbwrstby/adump
compatible:
dbwrprim (PRIMARY) : 18.0.0
dbwrstby : 18.3.0.0.0
dispatchers:
dbwrprim (PRIMARY) : (PROTOCOL=TCP) (SERVICE=dbwrprimXDB)
dbwrstby : (PROTOCOL=TCP) (SERVICE=dbwrstbyXDB)
fal_client:
dbwrprim (PRIMARY) : dbwrprim
dbwrstby : dbwrstby
sga_target:
dbwrprim (PRIMARY) : 1201668096
dbwrstby : 943718400
VALIDATE NETWORK CONFIGURATION
The VALIDATE NETWORK CONFIGURATION command performs network connectivity checks between members of a configuration.
The connect identifier for each connectivity check is generated based on the
DGConnectIdentifier property of the associated database.
Format
VALIDATE NETWORK CONFIGURATION FOR { ALL | member name };
Validating Network Configuration for a Specific Database
DGMGRL> VALIDATE NETWORK CONFIGURATION FOR dbwrstby;
Connecting to instance "dbwrstby" on database "dbwrstby" ...
Checking connectivity from instance "dbwrstby" on database "dbwrstby" to
instance "dbwrprim" on database "dbwprim"...
Succeeded.
Oracle Clusterware is not configured on database "dbwrstby".
VALIDATE STATIC CONNECT IDENTIFIER
The VALIDATE STATIC CONNECT IDENTIFIER command validates the static connect identifier of a database.
To perform this validation, the broker makes a new connection to the database using a static connect identifier based on the StaticConnectIdentifer property of the database. A new attribute, STATIC_SERVICE=TRUE is added to the connect identifier to ensure that a connection to the database is established using only a static service, not a dynamic service.
Format
VALIDATE STATIC CONNECT IDENTIFIER FOR { ALL | database name };
Command Examples
Validation of Static Connect Identifier For a Database on Which
Oracle Clusterware Is Configured
DGMGRL> VALIDATE STATIC CONNECT IDENTIFIER FOR dbwrstby;
Oracle Clusterware is not configured on database "dbwrstby".
SHOW ALL
The SHOW ALL command shows the values of DGMGRL CLI properties.
Format SHOW ALL;
Command Example
DGMGRL> SHOW ALL;
debug ON
echo OFF
time OFF
observerconfigfile = observer.ora
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba
