New Features of Data Guard in Oracle Database 19c

These are the changes in Oracle Data Guard Concepts and Administration for Oracle Database Release 19c.

  • The process of flashing back a physical standby to a point in time that was captured on the primary is simplified by automatically replicating restore points from primary to the standby.
  • When flashback or point-in-time recovery is performed on the primary database, a standby that is in mounted mode can automatically follow the same recovery procedure performed on the primary.
  • You can enable the Oracle Database In-Memory Column Store and Data Guard Multi-Instance Redo Apply at the same time on an Active Data Guard standby database.
  • DML operations can be performed on Active Data Guard standby instances. When an invalid PL/SQL object is run on an ADG standby database, the object is automatically recompiled.

These are the changes in Oracle Data Guard Broker for Changes in Oracle Database Release 19c.

  • You can dynamically change the fast-start failover target to a specified member in the list without disabling fast-start failover.
  • Without impacting your current environment, you can test how fast-start failover will work by using the observe-only mode of fast-start failover.
  • The broker configuration can be exported and stored in a text file, thereby enabling you to create a backup of the current broker configuration. When required, you can recreate the broker configuration using the metadata in the exported file. The new commands EXPORT CONFIGURATION and IMPORT CONFIGURATION are used to export and import a broker configuration.
  • New commands are available to set, modify, and display the value of database initialization parameters in a database, far sync instance, or Recovery Appliance. Values set using these commands are directly applied to the database and are not stored in the broker configuration file. The new commands are as follows:
    • EDIT DATABASE
    • EDIT DATABASE RESET
    • EDIT FAR_SYNC RESET
    • EDIT RECOVERY_APPLIANCE
    • EDIT RECOVERY_APPLIANCE RESET
    • SET TRACE_LEVEL

Thank you for giving your valuable time to read the above information.

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

Telegram Channel: https://t.me/helporacle

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

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

About The Author

"The fragrance always remains in the hand that gives the rose." I am a person who believes in sharing knowledge among all. My Oracle rewards are OCI, OCP, OCA.

Comments

  1. Pingback: 19c data guard new features | Oracle 19c Data Guard Broker new features

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.