New Features on Oracle 12c Dataguard

Generic filters
Exact matches only
Filter by Custom Post Type

SYSDG Privilege

For better separation of duty, Oracle Database now provides an Oracle Data Guard-specific administration privilege, SYSDG, to handle standard administration duties for Oracle Data Guard. This new privilege is based on the least privilege principle. The SYSDBA privilege continues to work as in previous releases.

Real-Time Cascading

Primary database redo can now be cascaded in real time as it is being written to the standby redo log file at a physical standby or a far sync instance. This feature is known as real-time cascading and it requires a license for the Oracle Active Data Guard option.

[adrotate banner=”3″]

Far Sync Instance

A new type of remote Oracle Data Guard destination, called a far sync instance, accepts redo from the primary database and then ships that redo to other members of the Oracle Data Guard configuration.


Maximum Availability mode now allows the LOG_ARCHIVE_DEST_n attributes SYNC and NOAFFIRM to be used together. This enables asynchronous standby database to be deployed at a further distance from the primary site without increasing the impact on primary database performance.

Other Notable Changes are

  • Online relocation of datafiles for standby/primary database
  • Support for GDS in the dataguard broker.
  • When you perform a switchover from an Oracle RAC primary database to a physical standby database, it is no¬† longer necessary to shut down all but one primary database instance.
  • The USING CURRENT LOGFILE clause is no longer required to start real-time apply.
  • You can create a physical standby of a multitenant container database (CDB)

Liked this Article.?

We have lot more interesting posts like this!  Join more than 5000 subscribers who stays ahead on technology.

By entering your email, you agree to the Terms and Conditions and Privacy Policy and cookies usage

You Make like the below posts

How to Recover Dropped Table Using RMAN

Recover Dropped Table using RMAN is a new feature introduced in Oracle 12c. This document explains the steps involved. ‘Reover Table’ is the command used. Watch out the youtube video in the post

About The Author

Share on

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest

Leave a comment

Your email address will not be published.

Can't Find What You Are Looking For?.

Please enter the details below. We will try our best for you :-)

We have more amazing posts

Try searching here

lick edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve