Oracle 19c Restore Point Replication From Primary To Standby

Oracle 19c Restore Point Replication From Primary To Standby >>>> GUARANTEE_FLASHBACK_DATABASE=NO <<<<< ---- don't rely on it



SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production




SQL> def
DEFINE _DATE           = "18-FEB-26" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcl" (CHAR)
DEFINE _USER           = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1903000000" (CHAR)



create restore point grp_test guarantee flashback database;

Restore point created.



create restore point grp_test guarantee flashback database;

-- on prim 


set linesize 300 
col NAME for a30
col GUARANTEE_FLASHBACK_DATABASE for a30
col time for a30
col REPLICATED for a14
select NAME,SCN, GUARANTEE_FLASHBACK_DATABASE, TIME,  REPLICATED from v$restore_point;


NAME                                  SCN GUARANTEE_FLASHBACK_DATABASE   TIME                           REPLICATED
------------------------------ ---------- ------------------------------ ------------------------------ --------------
GRP_TEST                          2538078 YES                            18-FEB-26 04.11.46.000000000   NO


SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT;


NAME                                  SCN TIME                           DATABASE_INCARNATION# GUARANTEE_FLASHBACK_DATABASE   STORAGE_SIZE
------------------------------ ---------- ------------------------------ --------------------- ------------------------------ ------------
GRP_TEST                          2538078 18-FEB-26 04.11.46.000000000                       2 YES                               209715200




-- standby   GUARANTEE_FLASHBACK_DATABASE NO!!!! IMP
set linesize 300 
col NAME for a30
col GUARANTEE_FLASHBACK_DATABASE for a30
col time for a30
col REPLICATED for a14
select NAME,SCN, GUARANTEE_FLASHBACK_DATABASE, TIME,  REPLICATED from v$restore_point;


NAME                                  SCN GUARANTEE_FLASHBACK_DATABASE   TIME                           REPLICATED  ---<<<<<
------------------------------ ---------- ------------------------------ ------------------------------ --------------
GRP_TEST_PRIMARY                  2538078 NO                             18-FEB-26 04.11.46.000000000   YES  ------<<<<<<<<<<<<<<<<<<<<<<<


 SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT;

NAME                                  SCN TIME                           DATABASE_INCARNATION# GUARANTEE_FLASHBACK_DATABASE   STORAGE_SIZE
------------------------------ ---------- ------------------------------ --------------------- ------------------------------ ------------
GRP_TEST_PRIMARY                  2538078 18-FEB-26 04.11.46.000000000                       2 NO                                        0




to drop 

DROP RESTORE POINT GRP_TEST;

Restore point dropped.