Oracle Flashback

Replication Agent can replicate Oracle Flashback operations performed at the table level and the transaction level.

Replication Agent can replicate Flashback Table commands to restore a database back to a System Change Number (SCN), timestamp, or restore point within the threshold specified by the Oracle UNDO_RETENTION parameter. If a table has been marked for replication, Replication Agent can replicate any DML changes that result from executing the contents of the UNDO_SQL column of the Oracle FLASHBACK_TRANSACTION_QUERY view.
Replication Agent replicates these Oracle DDL commands:
- DROP TABLE table (when the Recycle Bin is enabled)
- FLASHBACK TABLE table TO BEFORE DROP
- PURGE TABLE table
- PURGE INDEX index
- PURGE TABLESPACE tablespace
- PURGE RECYCLEBIN
- PURGE DBA_RECYCLEBIN
Note: Since the replicate database may not be an exact copy of the primary database, these DDL commands may not execute successfully at the replicate database or may have a different result at the replicate database. For example, the PURGE DBA_RECYCLEBIN command purges more objects at the replicate database if the Recycle Bin for the replicate database contains more objects than the primary database Recycle Bin.
Replication Agent can read from the Oracle Flash Recovery Area if the pdb_archive_path configuration parameter is set to that location.

Requirements for Oracle Flashback
Observe these requirements when using Oracle Flashback with Replication Agent.
Limitations to Oracle Flashback
Replication of Oracle Flashback commands is subject to some limitations.
Disabling Oracle Recycle Bin
If you do not intend to use the Recycle Bin at the replicate Oracle database, you can manually disable it.
Dropped Objects and Article Status
If a marked table is dropped while the Recycle Bin is enabled at the primary database, the ra_helparticle command still reports the status of the corresponding article as Current. ra_helparticle reports the status of the corresponding article as Dropped only after the dropped table is purged from the primary database Recycle Bin.
Disabling Flashback Replication with Recycle Bin Disabled
Disable the replication of Oracle Flashback DDL commands when the Recycle Bin is disabled.

Parent topic: Oracle-Specific Considerations