My Oracle Support Banner

19c (New Feature) : Automatic flashback on standby (PDB) when flashback on primary (PDB) done and DB open with reset-logs (Doc ID 2465579.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.1 BETA and later
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation
delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

PDB name: pdb1



 -- After we perform a PDB PITR or PDB Flashback on a primary, we can either restore the PDB or flashback the PDB on the standby to let the standby follow the primary.
 -- When a PDB PITR or PDB flashback is performed on the primary, and redo for the start of the operation is encountered for the first time, the MRP at the standby terminates with error ORA-39874, followed by the supplemental error ORA-39873.


 -- The COMPATIBLE initialization parameter must be set to 19.0.0 or higher .
 -- Parameter "_standby_auto_flashback" is TRUE and flashback logs in place.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.