Oracle 18c Data Guard Broker Enhancements

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

Leave a Reply

Your email address will not be published. Required fields are marked *