This article was written by Skant Gupta and Joel Perez in Oracle OTN.

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

Before starting, if you want to read about how to build an Oracle Dataguard Configuration in Cloud, you can read here:

#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

#2 Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console

#3 Oracle Cloud (DBaaS): Reinstating a Failed Primary Database using dbaascli utility ( Oracle Data Guard on Cloud )

#4 Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard

 

Now, Let's start to read..

 

Oracle Data Guard is an Oracle solution that seems will improve in a endless way. Every Oracle Release we have new features that perhaps we never expected to have.

Oracle 18c is not the exception, we have amazing new features, So.. Let's see..

 

New Broker VALIDATE commands

Personally, at the time to check or correct Oracle Data Guard configurations, one of the most common problems is the network configuration. Sometimes we are building RAC-RAC configurations with many servers.. many IPs.. etc.. and it's natural we can miss a name.. and IP.. etc.. at the end we can have some problems when this configuration is working and we have to start the tedious job to check every single detail.. ( Network Configuration.. Parameters.. etc.. ) to find where it's the problem.. With these 3 following commands we will be able to save a lot of time when we face that kind of difficulties..

 

VALIDATE DATABASE SPFILE

  • Validate parameters settings between the Primary and a Standby database.

VALIDATE NETWORK CONFIGURATION

  • Validate the network setup between all databases in the configuration

VALIDATE STATIC CONNECT IDENTIFIER

  • Verifies the static connect identifier setup in Single Instance databases the do not have Oracle Restart.

If you want to read rest to the article, go across this link :Oracle 18c and its impact on DBAs or link: https://community.oracle.com/blogs/Sir.DBaaSJoelPerez/2017/10/25/oracle-18c-new-features-for-oracle-data-guard-what-s-news

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp