Oracle 18c: New Features for Oracle Data Guard

    Oct 30, 2017 3:47:17 PM by Skant Gupta

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

    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: 

    Skant Gupta’s LinkedIn: 

    LinkedIn Group: Oracle Cloud DBAAS

    Facebook Page: OracleHelp

     

     

    Tags: Oracle

    Skant Gupta

    Written by Skant Gupta

    Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. He is also Technical Writer on http://www.oracle.com/technetwork/es/articles/index.html and http://www.oracle.com/technetwork/pt/articles/index.html with more than 30 article published in Oracle Technical Network.