Data Guard 12.2 New Features Deep-Dive

Data Guard 12.2 New Features Deep-Dive

By Charles Kim, Ace Director and President of Viscosity North America

[hr width=”2px” color=”#2980b9″ style=”solid”][/hr]

January, 2017

Oracle Database 12c Release 2, packs a multitude of Data Guard 12.2 New Features with high availability, data protection, and disaster recovery. Through the new functionality shared in this paper, DBAs can provide better protection for mission critical production databases from human errors, data corruptions, failures, and disasters. With the new features in Oracle 12.2, DBAs can deliver a robust reporting environment while addressing corporate disaster recovery goals.

Create a Standby Database with DBCA

Starting with this release, we can leverage the Database Configuration Assistant (DBCA) command-line interface, to instantiate the Data Guard standby database from the primary database. Leveraging the DBCA command-line interface, will eliminate many of the manual steps needed to create a standby database. With the DBCA command-line interface, we can also embed post instantiation scripts to be executed with the –customScripts option, as a post standby database instantiation process. For multiple scripts, we can supply a list of script names followed by a comma. The scripts will be executed in the order of the supplied list.
As of this release, several restrictions apply. First, only non-multitenant, primary databases can be instantiated as standby databases. Also, RAC physical standby databases cannot be created. To convert the single instance database to RAC, DBAs can leverage OEM Cloud Control.
DBCA offers a new -createDuplicateDB parameter, to duplicate a database from the primary database. The –createAsStandby parameter, is available to duplicate a standby database from the primary database. Additional options for dbca with the – createDuplicateDB parameter are:

dbca -createDuplicateDB
-gdbName global_database_name
-primaryDBConnectionString easy_connect_string_to_primary -sid database_system_identifier
[-dbUniqueName db_unique_name_for_standby]] [-customScripts scripts_list]
For the –primaryDBConnectionString, we can provide the easy connect string in the form of
This eliminates the need to create a TNSNAMES.ORA entry.

[hr width=”1px” color=”#16a085″ style=”dashed”][/hr]

To receive the full 9 page version of this document, please complete the download form provided.


Full Name (required)

Your Email (required)

Company (required)

Job Title (required)

[hr width=”2px” color=”#2980b9″ style=”solid”][/hr]


Other Viscosity Services Include:

  • Virtualization of Oracle on VMware / VBlock
  • Real Application Clusters (RAC)
  • Data Guard / ASM
  • GoldenGate / Shareplex
  • Database Performance Tuning
  • Database Managed Services
  • Database Upgrades with Zero Downtime and Zero Risk
  • E-Business Suite Administration and Upgrades
  • Exadata
  • Exadata Managed Services
  • Data Warehousing
  • Big Data (Cloudera with Hadoop and NoSQL)
  • Consolidation
  • SOA / ADF
  • License and Asset Management Services

Why Choose Us

[accordiancontainer id=”ske_container61″ effect=”1″ itemno=”1″ togacc=”1″ hoverpause=”0″] [accwrap] [acctitle]About Us[/acctitle] [acccontent]Viscosity is a recognized premier consulting firm of database technologies, cloud, and application development. Viscosity was founded by industry and authored experts. Many of our experts are prominent thought leaders with backgrounds in Oracle, VMWare, VCE, EMC, and Informatica. These capacities include Oracle Database, RAC Development, Oracle Consulting and Oracle Technical Architecture, Design and Performance Tuning. Contact us to learn more about how you can maintain and maximize your investments.[/acccontent][/accwrap] [accwrap] [acctitle]Our Expertise[/acctitle] [acccontent]Viscosity was formed by former Oracle employees each of which worked in various capacities within Oracle Corporation. These capacities include Oracle Database, RAC Development, Oracle Consulting and Oracle Technical Architects, Design and Performance Tuning experts. Viscosity's Oracle Center of Expertise has developed best practices and tight partner relationships to implement world-class solutions. Our vast experience and intellectual property give customers insight into what is driving IT complexity. We can deliver a set of practical executable plans for simplifying IT infrastructure, helping reduce operating costs while freeing up resources for new business initiatives.[/acccontent][/accwrap][/accordiancontainer]