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 JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.1 BETA and laterInformation in this document applies to any platform.
Purpose
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.
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.
-- 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.
Scope
-- The COMPATIBLE initialization parameter must be set to 19.0.0 or higher .
-- Parameter "_standby_auto_flashback" is TRUE and flashback logs in place.
-- Parameter "_standby_auto_flashback" is TRUE and flashback logs in place.
Details
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
| Purpose |
| Scope |
| Details |