Now from Oracle 19c onward , if we’ve to create a guarantee restore point in Standby configuration then we don’t need to create it on the physical standby database side , The restore point will automatically get created on the physical standby side too with the name of <Restore_Point_Name_Primary>.
Note : For the automatic creation of guarantee restore point on the physical standby side the logshipping must be enable between primary & Physical Standby database and the MRP should also be in active status otherwise the automatic GRP creation in physical standby side will fail , The creation of guarantee restore point doesn’t appear in the standby database’s log but we can see it on the v$restore_point view.
Connect To PROD Database & Create Guarantee Restore Point
Primary Database NAME | PROD |
Standby Database Name | DR_DB |
SQL> create restore point TEST guarantee flashback database;
Restore point created.
SQL> Set lines 300
SQL> Col con_id for 99999999
SQL> Col name for a40
SQL> Col preserved for a20
SQL> Col time for a40
SQL> Col guarantee_flashback_database for a40
SQL> Select con_id,name,time,preserved,guarantee_flashback_database from v$restore_point;
CON_ID NAME TIME PRESERVED GUARANTEE_FLASHBACK_DATABASE
--------------------------------------------------------------------------
0 TEST 18-NOV-2023 01.52.60.00000 AM YES YES
Connect To DR_DB Database & check the automatic creation of restore point
SQL> Set lines 300
SQL> Col con_id for 99999999
SQL> Col name for a40
SQL> Col preserved for a20
SQL> Col time for a40
SQL> Col guarantee_flashback_database for a40
SQL> Select con_id,name,time,preserved,guarantee_flashback_database from v$restore_point;
CON_ID NAME TIME PRESERVED GUARANTEE_FLASHBACK_DATABASE
--------------------------------------------------------------------------
0 TEST_PRIMARY 18-NOV-2023 01.52.60.00000 AM NO NO
