Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
Oracle 18c: Oracle Data Guard新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
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 NETWORK CONFIGURATION
VALIDATE STATIC CONNECT IDENTIFIER
Multi-Instance Redo Apply
– Multi-Instance Redo Apply allows all standby nodes to participate in recovery
– In-memory DB (IMC) on Active Data Guard allows:
– IMC now works with Multi-Instance Redo Apply!
– Multi-Instance Redo apply also works with BCT
* Available only on Exadata and Oracle Cloud Offerings
18c: RMAN and Data Guard Enhancements
Active Data Guard Sync
RECOVER STANDBY DATABASE FROM SERVICE primary_db;
Creating GTTs on Active Data Guard
– Creating GTTs today will fail when executed on Active Data Guard
– In Oracle Database 18c CREATE GLOBAL TEMPORARY TABLE on an Active Data Guard standby will:
Transient tables useful for reporting applications
Global temporary tables
Persistent, shared (global) table definition
Temporary, private (session-based) data content
Private temporary tables (18c)Temporary, private (session-based) table definition
Temporary, private (session-based) data content
Executing DML on Active Data Guard
– DML Re-direction automatically performed from Active Data Guard standby to the Primary without compromising ACID
Keep Buffer Cache at Role Change
How often we did not dream for having a switchover without losing some transactions because of that..
Well, part of that dream “come true”..
– The database buffer cache state will be maintained on an ADG standby during a role change
– Automatic, nothing to set up.
Control login attempts
– The ADG_ACCOUNT_INFO_TRACKING parameter extends the control of user account security information and reaction.
– ‘GLOBAL’ triggers the new secure behavior
Data Guard and No Force Logging
How often you have been in the situation to repair/reinstate an Standby Database because a load was done in “No Logging mode”.
It was really a hard situation for many companies to know that some specific loads could be done very efficient and fast in “No Logging mode” but sometimes there was not another option if we wanted to preserve the health state of our standby databases. Now, we have a new feature to make more versatile some specific loads in “No Logging mode”
In Oracle Release 12.1 & 12.2 there a lot of new features that perhaps you have not experimented up to now. Here we have a list of all them so that you can differentiate to what release belongs the new features you will use.
RMAN
Oracle 18c: RMAN New Features.. What’s NEWS..
Review – Data Guard 12.1 New Features Summary
Data Guard
Active Data Guard
Review – Data Guard 12.2 New Features Summary
Data Guard
Active Data Guard
this is the end of this article, we hope it can be useful.. Stay tune for more Oracle Database Cloud articles.
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
Author Bios:
Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com
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. Skant website link: oracle-help.co
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
[…] #15 Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS.. […]
About the author