Automatic Flashback (or PITR) Standby
Beginning with Oracle 19c, when executing FLASHBACK DATABASE command or performing a Point-In-Time Recovery (PITR) on the primary database, the Data Guard standby will also be automatically flashed back , ensuring it does not fall out of sync — provided that Flashback Database is enabled. This feature is controlled by the hidden parameter _ standby_auto_flashback . In the following text, we compare the Data Guard behavior in Oracle 18c vs 19c when performing a flashback or PITR on the primary database. Effect of Flashback Operations on the Standby (Oracle 18c) Primary — Oracle 18c SQL * Plus: Release 18.0 .0 .0 .0 – Production on Thu Jul 2 08 : 56 : 22 2020 SQL > select current_scn from v$database; CURRENT_SCN ———————— 784527897542 SQL > create table mt1 as select * from v$datafile; Table created. SQL > startup force; SQL > startup mount force; SQL > flashback database t...