Starting 19c, Restore points that are created on a primary database are automatically replicated to the standby database. The restore points created on the standby database are called replicated restore points. Irrespective of whether a restore point on the primary database is a guaranteed restore point or a normal restore point, the corresponding replicated restore point is always a normal restore point.
Oracle Database automatically replicates restore points from a primary database to the standby database when the following conditions are met:
- COMPATIBLE initialization parameter for both the primary database and the standby database is set to 19.0.0 or higher
- primary database is open
- A restore point that is created on a primary database when the primary is in mount mode is not replicated. This restriction is because the restore point information is replicated though the redo.
- MRP Process takes care of creating restore point in standby
- The restore point will be named suffixed with _PRIMARY in standby.
Follow Me!!!