Sunday, May 12, 2019

Oracle 19c New Features - Automatic flashback standby database when Primary database is flashed back

Prior to Oracle 19c, when using the "Flashback Database" feature on a primary database in a data guard environment would result in a standby database which is no longer in sync with the primary database; in previous releases, in order to ensure both primary and secondary are synced, then a manual procedure to flash back to standby database was required.

Starting with Oracle 19c, a standby database that is in a mounted state can automatically follow the primary database after a RESETLOGS operation on the primary. This simplifies standby management after a RESETLOGS operation on the primary.

This process is handled by the MRP (Managed Recovery Process) process that will automatically do the work for us.

For more information, see: https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-252097AC-3070-43B6-88D8-919AE27F97AD

2 comments: